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

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.

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

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

"Karyn" wrote in message
...
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.

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

It is not working it says #NAME?

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

"Daniel CHEN" wrote:

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

"Karyn" wrote in message
...
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.

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

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

On Fri, 17 Mar 2006 14:28:20 -0800, Karyn
wrote:

It is not working it says #NAME?

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

"Daniel CHEN" wrote:

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

"Karyn" wrote in message
...
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.




Gord Dibben MS Excel MVP