SUMIF HELP PLEASE

[Guest]

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)*(D2146=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

 

[Frank Kabel]

Hi
=SUMPRODUCT(--(C2:C146>=DATE(2004,11,1)),--(D2146=3),F2:F146)

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Arvi Laanemets]

Hi

=SUMPRODUCT(--(C2:C146>=DATE(2004,1,11)),--(D2146=3),(F2:F146))


Arvi Laanemets