=SUMPRODUCT(--(A1:A100="Reward"),--(B1:B100="Yes"))
works for me, but with a result of 6
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"st120869" wrote in
message ...
THanks, I get a #value error.
I ahve include some text below
Reward no
Reward no
Reward Yes
Reward Yes
Reward Yes
Reward Yes
Reward Yes
Reward Yes
xx1 Yes
the result I would expect to see if criteria is column A ="reward" &
column B = "yes" would be 7
--
st120869
------------------------------------------------------------------------
st120869's Profile:
http://www.excelforum.com/member.php...o&userid=18330
View this thread: http://www.excelforum.com/showthread...hreadid=517741