only count designated rows
 

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.

only count designated rows
 

Have a look in the help index for SUBTOTAL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gerald" wrote in message
...
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.

only count designated rows
 

Hi,

Try this

=SUBTOTAL(109,A1:A10)

Mike

"Gerald" wrote:

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.

only count designated rows
 

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

"Gerald" wrote:

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.