How to use Subtotal commend in Numbers?

ArchitLohia wrote:

So, in this table, if I filter columns by type, how do I get Total of Standard and Non-Standard?

Using SUMIFS you could do something like this:

=SUMIFS(Table 1::Qty,Table 1::'Type ',A2)

Using Categories, you could do this:

(you get that dropdown by clicking the "gear" symbol)

Giving you this:

SG

Let's say you have a table like this:

You can use the Categories feature of Numbers like this:

Open the "Organize" Panel on the right while the table is active

Then click the slider to enable categories:

Now select the cell in the same column as the values you want a subtotal for (This should reveal a "sprocket" icon):

Select the "Subtotal" option from the sprocket menu

Use the expose triangle to hide or reveal the details for each category

What do you mean by "subtotal command"? Are you referring to Categories, as in this 'Categories' template at File > New in your menu?

If you filter on a row this will still give you the subtotals for the entire dataset.

One way to get subtotals for a filtered dataset is to use SUMIFS.

Say you want to filter on TRUE here and get filtered subtotals for Andy and Chloe. You could do something like this:

=SUMIFS(Amount,Table 1::Name,A2,Include,TRUE)

(Substitute ; for , in the formula if your region uses , as a decimal separator)

Or you can get the same result without a formula by adding two categories in the right sidebar like this:

SG

ArchitLohia wrote:

So, in this table, if I filter columns by type, how do I get Total of Standard and Non-Standard?

Using SUMIFS you could do something like this:

=SUMIFS(Table 1::Qty,Table 1::'Type ',A2)

Using Categories, you could do this:

Giving you this:

SG

Hi ArchitLohia,

What criterion/criteria are you using for the filter?

That could be the key in a formula using the SUMIF function.

Also, have a look at the Categories feature in Numbers 10.x

More information will help us to help you. A screen shot of part of your unfiltered table will be informative.

Regards,

Ian.

See the two previous posts from me and SG