To summarize project status in Numbers on a Mac, organize your source table so each row represents one project or work item, then create a pivot table with project status as the row field and a count of items as the value. The result shows how many items are in each status, which is useful for a report when the source data is clean and the counts answer the question you need.

Prepare the project data

Use a single source table with one header row and consistent columns such as Project, Work Item, Status, Owner, and Due Date. Keep one record per work item; avoid merged cells and blank or ambiguous status labels. For a simple status count, every row should represent one item to count. If you instead want one count per project, make sure there is only one row per project, or the pivot will count repeated project records as separate items.

Numbers requires a source table with at least one non-header data cell and does not support merged cells across adjacent rows as pivot-table source data. You can make a pivot from a whole table or a selected cell range. Create a pivot table in Numbers on Mac

Before building the summary, standardize values in the Status column—for example, use Not started, In progress, Blocked, and Complete consistently. Different spellings or extra spaces can form separate groups, making a report harder to read. Add new records to the source table before refreshing the summary.

Create the pivot table on your Mac

  1. Open the spreadsheet in Numbers and select a cell in the source table. For a report you plan to keep alongside the raw data, create the pivot on a new sheet: in the menu bar, choose Organize > Create Pivot Table > On New Sheet. If you selected a specific range, choose the corresponding For Selected Cells option. The new pivot starts blank until you add fields. Apple also documents a Pivot Table toolbar shortcut when a table is selected. Apple’s Mac pivot-table creation steps

  2. Select the new pivot table to open Pivot Options in the Organize sidebar. Drag Status into Rows. Drag Work Item into Values. Numbers places fields according to their data type by default, but you can move them manually between Rows, Columns, and Values. Add and arrange pivot table data in Numbers on Mac

  3. Click the edit-details control beside the Work Item value field and check Summarise by. Choose a count function for a field that has an entry on every record. Avoid a sum for text identifiers; a sum is appropriate only for numeric measures such as estimated hours, and answers a different question. Numbers offers functions for value fields, including sum and average, and lets you change how results display. Intro to pivot tables in Numbers on Mac

The pivot now gives one row per status and a count of work items in that group. If you also want workload by owner, add Owner as another row field or move it to Columns to compare owners side by side. Keep the layout narrow enough to scan: a report focused on overall status usually needs only the status grouping and one count. Totals and grand totals appear by default, and you can hide them from Pivot Options if they clutter the view.

Make the summary useful in a report

Treat the pivot as a count of records, not a judgment about project health. A status count does not reveal whether a blocked item is urgent or whether a large project is more important than a small one. Include an as-of date in a nearby cell or report heading, and define what each status means if readers may interpret labels differently.

If a total looks surprising, Control-click a populated pivot cell and choose Create Table for Source Data. Numbers creates a new table containing the source rows used for that value, helping you trace the count back to records. View the source data for a pivot table value in Numbers on Mac

When source records change, select the pivot, open Organize > Pivot Options, and choose Refresh. Numbers does not reflect source edits in the pivot until it is refreshed; its sidebar also shows when the pivot was last refreshed. Refresh a pivot table in Numbers on Mac

A practical final check is to compare the pivot’s grand total with the number of source records intended for the report. Investigate differences by checking the source range, blank work-item names, inconsistent statuses, and whether each record is meant to count. Refresh once more after edits, then use the resulting summary with its reporting date and status definitions so readers know what the counts cover.

Sources