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

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.

"Andrew" wrote:

I have a summary sheet where I want to know show the sum of all invoices paid
per month. In the "invoices" sheet I enter the invoices, the amount, data
paid etc.

I have tried to use sumif and, for the criteria, used dates as a serial
number to select any date range that is of interest.

Gives me an error and I'm out of ideas.

Andrew

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

=SUMPRODUCT(SUMIF(INDIRECT(TEXT(DATE(2008,ROW(INDI RECT("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)

"brenadine" wrote in message
...
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.

"Andrew" wrote:

I have a summary sheet where I want to know show the sum of all invoices
paid
per month. In the "invoices" sheet I enter the invoices, the amount, data
paid etc.

I have tried to use sumif and, for the criteria, used dates as a serial
number to select any date range that is of interest.

Gives me an error and I'm out of ideas.

Andrew