Sum column if date (year) is greater than 09

Solved/Closed

joanie - Jan 26, 2010 at 12:41 PM
joanie - Jan 26, 2010 at 04:22 PM

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

Sum column if date (year) is greater than 09
Check sum error - Guide
Excel copy column from one sheet to another automatically - Guide
How to convert column to row in notepad++ ✓ - Excel Forum
Fifa 09 requires hardware graphics acceleration - Video Games Forum
Count the number of times a value appears in a column ✓ - Office Software Forum

1 response

Answer 1 / 1

joanie
Jan 26, 2010 at 04:22 PM

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)

Similar discussions

Excel Sum Greater than but Less Than

VBA find column by name and sort

Sum values from one column if another column equals x

Auto generate serial number in excel based on Column

Converting rows of data in notepad to columns

Similar discussions

Subscribe To Our Newsletter!