Sum column if date (year) is greater than 09

[Solved/Closed]
Report
-
 joanie -
Hello,
Hi I'm trying to calculate 2 column if the date is greater than 2009

in Column A Column B Column C
5/31/2009 75 35
6/30/2009 40 20
12/2/2010 20 10


I need to take Column B minus Column C if the date is less than 2009. Can some please provide me the right formula to use?

Thank you very much for your help

Best,
Joan

1 reply

I was able to figured it out. Here's the formula:

=SUMIF(A2:A4,"<1/1/2010",B2:B4)-SUMIF(A2:A4,"<1/1/2010",C2:C4)
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month