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" <[email protected]> wrote in message
news:[email protected]...
>
> 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" <[email protected]> wrote:

>=SUBTOTAL(109,A1:A20)