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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"LOU" schrieb im Newsbeitrag
...
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