Summing dates

[shyguy44]

Not sure if best to use a sum if or sumproduct. I have excel 2003

In column A I have a list of dates in the format 2-Jan-2009 all the way up to 3-Sep-11

In column C i have a cost and in column D i have a return

I need a formula to calculate when jan09 and subsequent dates feb09 mar09 etc appears in column A then what the cost in column C will be and the return in column D

then a formula for jan 09 to appear and the sum of column D minus the sum of Column C to give the net

Thanks

 

[T. Valko]

Thanks Biff

Was able just to enter jan 09 feb 09 and copy down, and even though shows 01-01-209 in formula bar it works ok

OK, that'll work.