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.

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

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

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

.