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?