Summary Cells on Filtered

[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

 

[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