Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum of worksheets.
I have a work book with 31 sheets,1...31, that is dates in a month. And it's
a summary sheet at the end of the same work book. I try to create a formel that will allow me to enter a start date and end date witch will provide a sum of the info given between the given range,date. Summary sheet have date from A6:A36 and the spesific info is from O6:O36 Start date in Q42, End date in R42 and S42 is the cell where i want the sum calculated. HOW TO FIX THIS. ????????????????????????? RIP. |
#2
|
|||
|
|||
I'm having trouble following your post but the syntax I think you are looking for is: =SUM(Sheet1:Sheet2!A1) In other words: =SUM(FirstSheet:LastSheet!Range) -- nbrcrunch |
#3
|
|||
|
|||
Your post is a little confusing, but this formula will
sum O6:O36 on each sheet that falls in between the dates (actually just a number 1-31) that you specify in Q42 and R42: =SUM(SUMIF(INDIRECT("'"&ROW(INDIRECT(Q42&":"&R42)) &"'! O6:O36"),"0",INDIRECT("'"&ROW(INDIRECT(Q42&":"&R4 2))&"'! O6:O36"))) Array-entered, meaning press ctrl + shift + enter. HTH Jason Atlanta, GA -----Original Message----- I have a work book with 31 sheets,1...31, that is dates in a month. And it's a summary sheet at the end of the same work book. I try to create a formel that will allow me to enter a start date and end date witch will provide a sum of the info given between the given range,date. Summary sheet have date from A6:A36 and the spesific info is from O6:O36 Start date in Q42, End date in R42 and S42 is the cell where i want the sum calculated. HOW TO FIX THIS. ????????????????????????? RIP. . |
#4
|
|||
|
|||
Actually, you can shorten the formula to:
=SUM(SUMIF(INDIRECT("'"&ROW(INDIRECT(Q42&":"&R42)) &"'! O6:O36"),"0")) Jason -----Original Message----- Your post is a little confusing, but this formula will sum O6:O36 on each sheet that falls in between the dates (actually just a number 1-31) that you specify in Q42 and R42: =SUM(SUMIF(INDIRECT("'"&ROW(INDIRECT(Q42&":"&R42) )&"'! O6:O36"),"0",INDIRECT("'"&ROW(INDIRECT(Q42&":"&R 42))&"'! O6:O36"))) Array-entered, meaning press ctrl + shift + enter. HTH Jason Atlanta, GA -----Original Message----- I have a work book with 31 sheets,1...31, that is dates in a month. And it's a summary sheet at the end of the same work book. I try to create a formel that will allow me to enter a start date and end date witch will provide a sum of the info given between the given range,date. Summary sheet have date from A6:A36 and the spesific info is from O6:O36 Start date in Q42, End date in R42 and S42 is the cell where i want the sum calculated. HOW TO FIX THIS. ????????????????????????? RIP. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
Protect/unprotect all worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
Sort/Link Worksheets | Excel Worksheet Functions |