--(E123:E1111"Half Off")

Unless those are typos:

That array isn't the same size as the others and you're missing the = sign.

Biff

"Mike B" wrote in message
...

My old formula worked fine for finding the number based on two
criteria,
=SUMPRODUCT(-(J124:J1111=0),-(AV124:AV1111="yes"))

Now I want to add a third criteria,
=SUMPRODUCT(--(AV124:AV1111="yes"),--(E123:E1111"Half
Off"),--(J124:J1111=0),J124:J1111)

But now I get a #VALUE error....any ideas?


--
Mike B