sum visible row only
 

how do i sum visible rows and avoid summing hidden ones in a range?

sum visible row only
 

I got it

=SUBTOTAL(9,M3:M3650)

Im an idiot

"Qaspec" wrote:

how do i sum visible rows and avoid summing hidden ones in a range?

sum visible row only
 

It depends on the Excel version,

Excel 2003 and later

=SUBTOTAL,109,A1:A1000)

will sum only visible rows

For earlier versions you can do it if they are filtered

=SUBTOTAL(9,A1:A1000)

If they are hidden in earlier versions you need to write code to do it


--


Regards,


Peo Sjoblom




"Qaspec" wrote in message
...
how do i sum visible rows and avoid summing hidden ones in a range?