how do I auto sum several worksheet cells on to a new worksheet?

K

Karyn

I have a different worksheet for each day of the week which shows the lates
for invoices per department per store. I am trying to create a worksheet to
add all of the lates per department together for reporting to the POS.
 
D

Daniel CHEN

Try to use a function like this:
=SUM(Sheet1:Sheet8!A1)
' Sum all of A1 in 8 sheets.

Sheet1 to sheet8 should be continuous and use shift key to select them all.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
=================================
 
K

Karyn

It is not working it says #NAME?

Not sure what you mean by continuous and using shift to select them all
 
G

Gord Dibben

Karyn

=SUM(Sheet1:Sheet8!A1) entered in any cell on any sheet which is not
Sheet1:Sheet8

Sheets 1 through 8 do not have to be selected.

Even better is to insert a new dummy sheet at left and a new dummy sheet at
right-end of other sheets.

Name them Start and End

Formula =SUM(Start:End!A1)

Any new sheets can be inserted between these two dummy sheets.

Now it doesn't matter what the intervening sheets are named.


Gord Dibben MS Excel MVP

It is not working it says #NAME?

Not sure what you mean by continuous and using shift to select them all
Click to expand...

Gord Dibben MS Excel MVP
 
Top