can i sum up only visible cells?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum many unconnected cells 5
Paste visible cells? 8
Sum function changes arguments 1
#N/A In Cells 7
sum only visible cells 5
Cut & Paste in Excel without erasing cell borders? 1
Automatic update to SUM formula cell references. 6
Time Sum in Excel 1

Back
Top