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!!
Bookmarks