COUNTIF with OR Logic

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):

Please Login or Register  to view this content.

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.

Try this regular formula:

Formula:

Please Login or Register  to view this content.

Is that something you can work with?

Unable to test without your file but maybe this:

Formula:

Please Login or Register  to view this content.

Hi

Have you tried something like

Formula:

Please Login or Register  to view this content.

Originally Posted by Ron Coderre

Try this regular formula:

Formula:

Please Login or Register  to view this content.

Is that something you can work with?

It does Ron. I'll research why after-hours. Fun stuff, I know.

Thanks!

maybe

=SUMPRODUCT(COUNTIFS(PCodes,{1,2,3,4,5,6,9,10,13,14,15,16,17,18,19},Regions,{11;15;16}))