View Single Post
  #1   Report Post  
LOU
 
Posts: n/a
Default SUMIF HELP PLEASE

Column C = Date
Column D = Account Number
column F = Value

I need a sumif formula if the criteria meets both the requirements,

=SUMIF(C2:C146=11/01/04)*(D2:D146=3)*(F2:F146))

It is not meeting the second criterua of the date and it is suming all the
"3" Account Numbers.

It should bring back the one value and not double it.

Thank you.
Lou