I now know from MS documentation that COUNTIFS does not support OR functionality.
I am attempting to count the number of times two criteria are met. In a defined range in column A, the values must be 1, 2, or 3, etc. and in column B the values must be 11, 15, or 16. My attempt thus far (which as stated earlier I now know to be incorrect):
=SUM(COUNTIFS(PCodes,{1,2,3,4,5,6,9,10,13,14,15,16,17,18,19},Regions,{11,15,16}))
If I were programming it, I would just loop the ranges with the value tests in another array and increment a counter when true. Surely I don't have to go this route...
Please assist.
Thanks.
Bookmarks