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

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

Bob Phillips

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I define date range criteria in SUMIF formula? 1
sum across 12 worksheets 3
sumifs, sumif with dates 6
Averaging many non-contiguous cells if they are blank 1
Need suggestions on layout to report/pivot 3
Multi-sheet sumif help 4
Sumif withdates 2
Editing an "IF" function across a worksheet/excel file 2

Top