Sum of amount with corresponding dates

  • Thread starter Thread starter Great13
  • Start date Start date
G

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?
 
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?
 
Back
Top