Thanks, this helps.

On Dec 12, 8:50 am, "Bob Phillips" wrote:
=SUMPRODUCT(--((A$1:A$248="7DCNA008")+(A$1:A$248="7DCNA008A")),--(J$1:J$248-="PO
Not in G4 FAS"))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Dave F" wrote in message

...



I need to test for either of two conditions in the same array. The
following SUMPRODUCT formula returns errors: =SUMPRODUCT((--OR(A$1:A
$248="7DCNA008"),--(A$1:A$248="7DCNA008A")),--(J$1:J$248="PO Not in
FAS"))

Essentially, I want to test for 7DCNA008 or 7DCNA008A in the range
A1:A248. How do I do this?

Dave- Hide quoted text -

- Show quoted text -