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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karyn - 16 Mar 2006 18:44 GMT

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.

Reply to this Message

Daniel CHEN - 17 Mar 2006 00:43 GMT

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.

Signature

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

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

Reply to this Message

Karyn - 17 Mar 2006 23:28 GMT

It is not working it says #NAME?

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

> Try to use a function like this:
> =SUM(Sheet1:Sheet8!A1)
[quoted text clipped - 6 lines]
> > to
> > add all of the lates per department together for reporting to the POS.

Reply to this Message

Gord Dibben - 19 Mar 2006 00:49 GMT

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?
>
[quoted text clipped - 10 lines]
>> > to
>> > add all of the lates per department together for reporting to the POS.

Gord Dibben MS Excel MVP

Reply to this Message