Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
subtotal a range of cells on a different worksheet | Excel Worksheet Functions | |||
Find & Replace within Unlocked Cells in a Protected Worksheet | Excel Discussion (Misc queries) | |||
Unlocking Cells when a worksheet is protected... | Excel Discussion (Misc queries) |