Sum of worksheets.

[Guest]

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.

 

[Jason Morin]

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&":"&R42))&"'!
O6:O36")))

Array-entered, meaning press ctrl + shift + enter.

HTH
Jason
Atlanta, GA

 

[Jason Morin]

Actually, you can shorten the formula to:

=SUM(SUMIF(INDIRECT("'"&ROW(INDIRECT(Q42&":"&R42))&"'!
O6:O36"),">0"))

Jason