can i sum up only visible cells?
 

I have a spreadsheet that numbers get pasted into each day, there are many
cells that are hidden within the spreadsheet and the "sum" function includes
them in the calculations, I don't want it to.

Is there an easy way of doing it?

=SUBTOTAL(109,A1:A20)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Wink" wrote in message
...

I have a spreadsheet that numbers get pasted into each day, there are many
cells that are hidden within the spreadsheet and the "sum" function
includes
them in the calculations, I don't want it to.

Is there an easy way of doing it?

Only with version 2003.

The SUBTOTAL Function in earlier versions does not accomodate hidden
cells/rows, only filtered cells/rows.

If an earlier version, copy the visible cells to another area or sheet and SUM
them there.


Gord Dibben Excel MVP

On Fri, 1 Apr 2005 11:34:54 +0200, "Niek Otten" wrote:

=SUBTOTAL(109,A1:A20)