sum column if date (year) is greater than 09 Solved/Closed

Question

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

joanie · Answer

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)

Sum column if date (year) is greater than 09

1 response

Similar discussions

Subscribe To Our Newsletter!