Try one of these:

=SUMPRODUCT(--(AQ233:AQ2000=AQ232),--(ISNUMBER(MATCH(AA233:AA2000,{"p0","p1"},0))))

=SUMPRODUCT((AQ233:AQ2000=AQ232)*(AA233:AA2000,{"p 0","p1"}))

Although the first formula is longer it is more efficient that the shorter
formula.

--
Biff
Microsoft Excel MVP


"nastech" wrote in message
...
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