Ooops! Typos:

--((B1:B4000<1)+(C1:C4000<)0)
SIGN((B1:B4000<1)+(C1:C4000<))

Should be:

--((B1:B4000<1)+(C1:C4000<0)0)
SIGN((B1:B4000<1)+(C1:C4000<0))


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
I tried variations of "--(OR(B1:B4000<1,C1:C4000<0, etc.)"

To use an "or" condition:

--((B1:B4000<1)+(C1:C4000<)0)

Or:

SIGN((B1:B4000<1)+(C1:C4000<))

if at least one of another dozen or so conditions are TRUE.

A dozen? That's a lot!

--
Biff
Microsoft Excel MVP


"andy62" wrote in message
...
I Have a SUMPRODUCT function which is working fine to return a count of
rows
meeting about 7 different criteria (e.g., --(A1:A4000="Yes"), etc.). To
this
function I need to add a component which returns TRUE if at least one of
another dozen or so conditions are TRUE. So it's like putting in another
dozen sets, all wrapped in an OR function. I tried variations of
"--(OR(B1:B4000<1,C1:C4000<0, etc.)" and then array-entering the whole
SUMPRODUCT function, but that doesn't work. Any ideas?

TIA