only count designated rows

  • Thread starter Thread starter Gerald
  • Start date Start date
G

Gerald

I have a spreadsheet that I have hidden some rows because of the size. I
would like to only get the sum of the rows that are not hidden. It seems when
I do the sum function it is counting all the rows including the hidden rows.
Please advise, thanks.
 
If you have a field that always has data in it, you could use this in a
different cell:

=subtotal(3,a2:a9999)

=Subtotal() won't count rows hidden by that autofilter.

-kc
 
Back
Top