SUBTOTAL function is used to sum up visible cells in a filtered list.

=SUBTOTAL(9,A:A) entered in B1 will give you the total of visible cells in
Column A when filtered.

You can add more arguments if you choose.

=SUBTOTAL(9,A:A)-A3 will work.

=SUBTOTAL(9,A:A)+12345 is also valid.


Gord Dibben MS Excel MVP

On Wed, 8 Jul 2009 10:20:02 -0700, Erik at E2open <Erik at
wrote:

Can you use math functions as arguments in a subtotal formula?

For example, if I want to =subtotal(9,A1,A2,(-2*A3)) is there a way to make
that work?

Thanks to any and all for help with this.
Erik