Autosum in Filtered List

Topic

New Reply

Stupid question of the day alert!!

I have a filtered list amongst which are 4 columns account name, to, from and revenue. When I choose account name I would like to see a list and a total of the revenue column.

In the main list I have tried autosum in the last revenue cell and have tried =SUM(G2:G2749) when when I filter no total shows.

Please help put a buffoon out of his misery.

Reply | Quote

Replies

Insert (at least) two rows above the field names (column headers) of your data table, and place the sum formula above the data table with a blank row in between.

BTW, the SUM function will add all cells, whether they are filtered or not. To add only the filtered cells, use SUBTOTAL:

=SUBTOTAL(9,G4:G2751)

(The formula takes two inserted rows into account)

Reply | Quote

Insert (at least) two rows above the field names (column headers) of your data table, and place the sum formula above the data table with a blank row in between.

BTW, the SUM function will add all cells, whether they are filtered or not. To add only the filtered cells, use SUBTOTAL:

=SUBTOTAL(9,G4:G2751)

(The formula takes two inserted rows into account)

Thanks Hans

Right on the money as usual

May I ask though what the 9 is in the formula?

Reply | Quote

SUBTOTAL can be used to aggregate data in several ways. The first argument specifies the operation to be used:
1 = AVERAGE
2 = COUNT
…
9 = SUM
etc.

See the Excel help or SUBTOTAL.

Reply | Quote

SUBTOTAL can be used to aggregate data in several ways. The first argument specifies the operation to be used:
1 = AVERAGE
2 = COUNT
…
9 = SUM
etc.

See the Excel help or SUBTOTAL.

Thanks for the explaination Hans that is a lot clearer

Reply | Quote

The 9 is the Function Number for SUM

Reply | Quote