Conditional sum

[PO]

Hi!

I use the formula =Sum("A1:A100") to perform a sum. However the user can
filter the data and then I want the formula to only perform the sum on the
filtered data (visible data).

How do I write this formula?

Regards
PO

 

[Guest]

Use the SUBTOTAL function

=SUBTOTAL(9,A1:A100)

will sum visible cells that have been filtered (from 2003 you can sum
visible cells that where other cells have been hidden as well), look in help
for other options like average and count


Regards,

Peo Sjoblom