Try this:

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

--
Biff
Microsoft Excel MVP


"Great13" wrote in message
...
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?