How to create Subtotal in Numbers

Fill down cell E2 to create E3 and E4. Be careful that the "categories" in column A are consistent in their spelling, "Category3" is not the same as "Category 3". If you are not careful, you might not sum everything you meant to sum. One way to be careful is to use a pop up menu for the cells in column A. This forces you to choose from a list of "categories" vs typing it in each time. This advice may or may not apply to your situation.

Instead of "A" and "B" which reference the entire columns A and B, you can use ranges such as A3:A9 and B3:B9.

When you type the "=" to start a formula, you can look up function(s) in the sidebar on the right to see what is required to complete the function(s).

"I replicated your example to the letter"

If that were true, you would see the same results in E2, E3 and E4 as shown in Badunit's example. there would be no error message in D2 as D2 does not contain a formula, and error messages occur only in cells where there is an error in the writing or the working of that formula.

Examine your version of the example closely and compare it cell by cell to the example. Correct the differences, and you should see the same results as shown in the example.

The syntax for SUMIF is this:

SUMIF(test-values, condition, sum-values)

test-values: the range of cells whose values are to be compared with 'condition.'
In the example, all non-header cells in column A, expressed in the formula as A

condition, include only the values that meet this condition

In the example, "=" (implied) the value in cell D2

sum-values the range of cells whose values are to be included in the sum (if the value in their row of column A

meets the 'condition'.

In the example, values in column B, where the same row of column A contains the same value as D2.

Numbers, in any version, is no more frustrating than any spreadsheet application with respect to this function. Take a closer look, work your way through it, and you'll succeed.

Regards,

Barry

There are no formulas in column D. I typed the three category names by hand. The formulas are in column E. The formula shown is in cell E2

Maybe the highlighting threw you off? With the cell selected (cell E2), Numbers highlights all of the cells and ranges being referenced by the formula. That would be column A, column B, and cell D2.

"I used pop up menu to have consistent data category."

Good move.

Regards,

Barry

PS: Badunit's second post (the one with the table and formula) contained the actual solution to your issue. Since you've already used yur "Solved" mark, please mark that post "Helpful" to bring it to the top section, where it will be easier to find by someone coming later with a smilar question.

B.

You can read this wonderful discussion carefully until the end. This solved the subtotal problems in Numbers for me.

Still don't get the filtering and the sumif with visible cells

These guys Rock.

Yo will have to supply more information to get the best answer. SUMIF sounds like the right one if you are trying to sum a list of things by IRS code.