Hi,

I have a formula in which I want to return a 1 to include else a 0 if
certain cells contain a value of + or - 10. Unfortunately this is returning
zeros even when a 1 should be returned.

=SUMPRODUCT(--(N57<=11),--(N57<=-11),--(Q57<=11),--(Q57<=-11),--(AB57<=11),--(AB57<=-11),1,0)

Any help gratefully appreciated.