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