View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Great13 Great13 is offline
external usenet poster
 
Posts: 1
Default Sum of amount with corresponding dates

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?