I really prefer the double unary operator, mostly because it makes it easier
to read, and discern conditions from sums. But using * as AND, and + as OR
makes sense:

I think this would work:
=SUMPRODUCT(--((X2:X500<"foo")*(X2:X500<"oof")),--(Y2:Y500<100),(Z2:Z500))

Thanks.

Thank you both for helping out.




Teethless mama wrote:
Try this:

=SUMPRODUCT((X2:X500<"foo")*(X2:X500<"oof")*(Y2 :Y500<100)*(Z2:Z500))

So, normally I would use this format for my conditional formulas:

[quoted text clipped - 11 lines]

thank you for any help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200703/1