Sum of amount with corresponding dates

[Great13]

Column C is full of $ amounts billed and the corresponding date (same row)
in column E reflects the date that bill was paid. I want to write a formula
that will Sum the numbers in column C adding each row ONLY if it has an
actual date on the same row in column E AND only if that date is in 2009. Is
this even possible?

 

[T. Valko]

Try this:

=SUMPRODUCT(--(YEAR(E2:E100)=2009),C2:C100)

 

[JBeaucaire]

Try something like this adjusted for a reasonable range:

=SUMPRODUCT(--(YEAR($E$1:$E$1000)=2009),$C$1:$C$1000)

Does that get you started?