=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?