Sum

[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

 

[Jacob Skaria]

With formula you cannot..You will have to use a macro .

If this post helps click Yes

 

[Ashish Mathur]

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

 

[Charabeuh]

With the function subtotal,

example:

if your data are in A2:A100

Put into A1 the formula: =SUBTOTAL(109,A2:A100)

 

[Jacob Skaria]

Thanks Ashish. Havent tried the Function_num range 101-111

 

[T. Valko]

The 100 series SUBTOTAL arguments are only available in Excel versions 2003
and later.

 

[Ashish Mathur]

You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Jacob Skaria]

Thanks Biff for the info..

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

If this post helps click Yes