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),D4:D25)

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