Sum

  • Thread starter Thread starter Fareez
  • Start date Start date
F

Fareez

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
 
With formula you cannot..You will have to use a macro .

If this post helps click Yes
 
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
 
With the function subtotal,

example:

if your data are in A2:A100

Put into A1 the formula: =SUBTOTAL(109,A2:A100)
 
The 100 series SUBTOTAL arguments are only available in Excel versions 2003
and later.
 
Thanks Biff for the info..

Have worked with CELL() but again the function do no return the height....

If this post helps click Yes
 
Back
Top