How can I define date range criteria in SUMIF formula?

[LisaR]

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??

 

[Bob Phillips]

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