If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I define date range criteria in SUMIF formula?
Hi,
I am trying to use excel to forecast payments owing in each month. If column A is a list of dates and column B the amounts owing how can I set up the SUMIF formula to provide, for example, the sum of all amounts owing in February 2010? I can get it to return a figure owing on a specific date: =SUMIF(C4:C25,DATE(2010,1,31),D425) However find I cannot get the right criteria for a range of dates (ie a month). Have tried for eg =DATE(2010,1,31) and this brings no result... What am I doing wrong?? |
#2
|
|||
|
|||
How can I define date range criteria in SUMIF formula?
A couple of ways
=SUMIF(C4:C25,"="&DATE(2010,2,1),D425)-SUMIF(C4:C25,"="&DATE(2010,3,1),D425) or SUMPRODUCT(--(C4:C25=--"2010-02-01"),--(C4:C25--"2010-03-01"),D425) HTH Bob "LisaR" wrote in message ... Hi, I am trying to use excel to forecast payments owing in each month. If column A is a list of dates and column B the amounts owing how can I set up the SUMIF formula to provide, for example, the sum of all amounts owing in February 2010? I can get it to return a figure owing on a specific date: =SUMIF(C4:C25,DATE(2010,1,31),D425) However find I cannot get the right criteria for a range of dates (ie a month). Have tried for eg =DATE(2010,1,31) and this brings no result... What am I doing wrong?? |
Thread Tools | |
Display Modes | |
|
|