Are you using:
=SUMPRODUCT((E1:E29001=V1),(F1:F29001=W1),(H1:H290 01))
It should be:
=SUMPRODUCT(--(E1:E29001=V1),--(F1:F29001=W1),--(H1:H29001))
note the '-' signs, they are very important,
Regards,
Alan.
"ml0" wrote in message
...
Alan,
Thanks for your posting. I copied your formula and change the cell
reference to fit my spreadsheet and got a value of zero. This is what
my formula looks like:
=SUMPRODUCT((E1:E29001=V1),(F1:F29001=W1),(H1:H290 01))
Where V1 and W1 are the text criteria and colum E and F are where the
criteria needs to be tested and column H is the values that I need
added. I tried it by typing in text values instead of the cell
reference and got the same results. Am I doing something wrong?
Thanks
--
ml0
------------------------------------------------------------------------
ml0's Profile:
http://www.excelforum.com/member.php...o&userid=31121
View this thread: http://www.excelforum.com/showthread...hreadid=507874