Hi everyone,

Hoping I can get some help. Trying to do a sumproduct that counts one of two criteria. The results need to count if either of the following happen:

1) The number in column J is above 625
or
2) the partial text "CA" is in either column M or column

I came up with the following formula. However I keep getting a 0 answer, which is not correct:

=SUMPRODUCT(--(Inventory!J3:J10000>625),--(Inventory!M3:M10000="*CA*")--(Inventory!O3:O10000="*CA*"))

Any help from the gurus would be greatly appreciated.

Thanks!!