Formula
 

What formula can I use to add a column of visible numbers without adding
numbers in the hiden rows?
This is what I have tried and it adds the hidden rows
=SUM(Production!F16:F81).

Thanks,
Bob

Formula
 

Hi Bob,

=Subtotal(9,Production!F16:F81)

should do the job ...
HTH
Carim

Formula
 

I cut and pasted the formula and it is still adding all the hidden cells in
that column.
Any suggestions.
Bob

"Carim" wrote:

Hi Bob,

=Subtotal(9,Production!F16:F81)

should do the job ...
HTH
Carim

Formula
 

Bob,

I thought your hidden rows where the result of a Filter ...

In your case, my suggestion would be to use to Insert Name Define all
cells in hidden rows and give this range the name Hidden...
Then your result will be = sum(wholerange)-sum(hidden)

HTH
Carim

Formula
 

Bob,

If you are using XL 2003, you may use :

=SUBTOTAL(109,yourRange)

Carim

Formula
 

I changed the 9 to 109 and it works great.

Thanks for your help.

Bob

"Carim" wrote:

Bob,

If you are using XL 2003, you may use :

=SUBTOTAL(109,yourRange)

Carim