Summary Cells on Filtered

  • Thread starter Thread starter graham feeley
  • Start date Start date
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
 
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
 
Back
Top