only count designated rows

[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.

 

[Don Guillett]

Have a look in the help index for SUBTOTAL

 

[Mike H]

Hi,

Try this

=SUBTOTAL(109,A1:A10)

Mike

 

[KC]

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