Hard to tell without knowing what "just doesn't work" means.
Sytactically, it's fine, though if you're counting, you'll get a
negative number - add another negation to make it positive.



In article ,
Mike B wrote:

Sorry, couple really stupid errors in my original post. How do I add a
third criteria to this formula:
=SUMPRODUCT(-(J124:J1111=1),-(AV124:AV1111="yes"))

This just doesn't work:
=SUMPRODUCT(-(J124:J1111=1),-(AV124:AV1111="yes"),-(V124:V1111="Half
Off"))