Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif based on dates
I have a table that in one column lists a date and in another column a dollar
amount. On the same sheet I have second table that in one column lists a date. In another column I want to add up the dollar amounts from the first table for dates equal to or less than the date in the second table. I thought that SUMIF would work, but it is not. I am getting zeros. I think there is a problem with the criteria. I used <=D12, where D12 is the cell in table 2 that contains the date. (I also tried it with quotation marks). But it is not working. Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif based on dates
Try it like this:
Sumif(criteriaRange,"<="&D12,sumRange) "IlliniEric" wrote: I have a table that in one column lists a date and in another column a dollar amount. On the same sheet I have second table that in one column lists a date. In another column I want to add up the dollar amounts from the first table for dates equal to or less than the date in the second table. I thought that SUMIF would work, but it is not. I am getting zeros. I think there is a problem with the criteria. I used <=D12, where D12 is the cell in table 2 that contains the date. (I also tried it with quotation marks). But it is not working. Any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif based on dates
Perfect! Thanks.
"Teethless mama" wrote: Try it like this: Sumif(criteriaRange,"<="&D12,sumRange) "IlliniEric" wrote: I have a table that in one column lists a date and in another column a dollar amount. On the same sheet I have second table that in one column lists a date. In another column I want to add up the dollar amounts from the first table for dates equal to or less than the date in the second table. I thought that SUMIF would work, but it is not. I am getting zeros. I think there is a problem with the criteria. I used <=D12, where D12 is the cell in table 2 that contains the date. (I also tried it with quotation marks). But it is not working. Any suggestions? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif based on dates
You're Welcome!
"IlliniEric" wrote: Perfect! Thanks. "Teethless mama" wrote: Try it like this: Sumif(criteriaRange,"<="&D12,sumRange) "IlliniEric" wrote: I have a table that in one column lists a date and in another column a dollar amount. On the same sheet I have second table that in one column lists a date. In another column I want to add up the dollar amounts from the first table for dates equal to or less than the date in the second table. I thought that SUMIF would work, but it is not. I am getting zeros. I think there is a problem with the criteria. I used <=D12, where D12 is the cell in table 2 that contains the date. (I also tried it with quotation marks). But it is not working. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif formula based on dates | Excel Worksheet Functions | |||
sumif using dates | Excel Discussion (Misc queries) | |||
SUMIF & COUNTIF based on dates | Excel Worksheet Functions | |||
I want to use sumif to sum up a column based on a range of dates | Excel Worksheet Functions | |||
SUMIF and Dates | Excel Worksheet Functions |