You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Jacob Skaria" wrote in message
...
Thanks Ashish. Havent tried the Function_num range 101-111

"Ashish Mathur" wrote:

Hi,

You could use the SUBTOTAL(109,range) formula. This formula will exclude
all rows:

1. which are manually hidden I.e. by Row Hide; or
2. which are concealed as a result of filtering

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Fareez" wrote in message
...
hi
I have hidden some rows, when i sum rows. is there any way to sum only
visible rows. that is it shold not sum hidden rows
thanks