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

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

Hi

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


Arvi Laanemets


"LOU" wrote in message
...
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