Summary Cells on Filtered

G

graham feeley

I have some cells that do ( count,sum,sumif) etc of my data.
But I need it to also work on a filtered worksheet????
Is it possible????
Regards
Graham
 
P

Peo Sjoblom

Look in help for SUBTOTAL, it will count, sum, average etc with filtered
rows.
It won't do sumif, but you can use somewhat more complex formulas for that
or a help column

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Top