in case anyone wanted to know, seems to get a true-false, use e.g.:
=SUMPRODUCT((AQ152:AQ1228=AQ12)*((AA152:AA1228="p0 ")+(AA152:AQ1228="p1")))0

"Max" wrote:

Try it as:
=SUMPRODUCT((AQ233:AQ2000=AQ232)*((AA233:AA2000="p 0")+(AA233:AA2000="p1")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"nastech" wrote:
hi, trying to test 2 colums, of 1 column: has either of 2 criteria..

=SUMPRODUCT(--(AQ233:AQ2000=AQ232),OR(--(AA233:AA2000="p0"),--(AA233:AA2000="p1"))) not quite working

singularly, does work: (but need to test for "p0" or "p1"), thanks
- how to OR() a sumproduct..

=SUMPRODUCT(--(AQ233:AQ2000=AQ232),--(AA233:AA2000="p0"))0