IF formula:enter value if it occured in the year 2008,otherwise 0

[Barbora]

Hi, I need help creating an IF formula. I need to enter value, if it happened
in 2008 (1/1/2008-12/31/2008), otherwise enter zero.
Let's say this is my chart:
2/12/08 $450
12/03/07 $230
5/01/08 $300
Now i need a new column, which will add up all the values from 2008, but
will ignore those that happend in 2007 or will happen in 2009. In other
words, i need the result: 450+0+300

I am using Windows XP Professional.

Thank you for the help!

 

[Tyro]

If your dates are in A1:A3 and your dollars are in B1:B3 then is one way:

=SUMPRODUCT(--(YEAR(A1:A3)=2008),B1:B3)

Tyro