Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with SUMIF using a range of dates as criteria | Excel Discussion (Misc queries) | |||
I want to use sumif to sum up a column based on a range of dates | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
can I use a range of dates as a criteria when using sumif? | Excel Worksheet Functions | |||
SUMIF across a range of worksheets | Excel Worksheet Functions |