what are the addresses for your defined ranges?
do you have any merged cells?
I am most confused by the difference in response for the two sumproduct
formulas

"hochedez" wrote:


Hello everyone, :)

A very quick question, but nonetheless very intriguing to me (I just
lost 4h on that :( )

I don't understand why my first formula works, and the second and third
don't.

{=SUM(IF(FiscYear="2003",IF(IncomeFeeID="RB",Amoun t,0),0))}

=SUMPRODUCT((FiscYear="2003")*(IncomeFeeID="RB")*A mount)
(result is #value)

=SUMPRODUCT((FiscYear="2003")*(IncomeFeeID="RB"),A mount)
(this one could work too I thought, but result in a 0)

I am simply trying to sum (amount) when the fiscal year is 2003 and
IncomeFeeId is RB...

What am I missing?

Thank you so much for your help!


--
hochedez
------------------------------------------------------------------------
hochedez's Profile: http://www.excelforum.com/member.php...fo&userid=5734
View this thread: http://www.excelforum.com/showthread...hreadid=465897