Sum

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
 
J

Jacob Skaria

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

If this post helps click Yes
 
A

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
 
C

Charabeuh

With the function subtotal,

example:

if your data are in A2:A100

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

T. Valko

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with LARGE function 3
Adding totals in columns 2
How to add only the adding filtered result using SUM function? 7
hidden rows problem 7
What is the "--" (double dash) in MS Excel formula? 2
need to know how to get the sum of right product returned 5
How do I get "auto sum" to subtract hidden cell values from total 3
sum of multiple rows 2

Top