SumIf function, How set range between dates and across worksheets?

  • Thread starter Thread starter brenadine
  • Start date Start date
B

brenadine

Can anyone help me do this when the range is across worksheets? I have a
worksheet for each month, each row in an invoice with the amount in column I
and the date payment was posted in column M. I want to total the payments
made by date posted, so they could be on previous worksheets.
 
=SUMPRODUCT(SUMIF(INDIRECT(TEXT(DATE(2008,ROW(INDIRECT("1:12")),1),"mmm")&"!M1:M10"),--"2008-06-01",
INDIRECT(TEXT(DATE(2008,ROW(INDIRECT("1:12")),1),"mmm")&"!I1:I10")))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top