Countif in VBA with Multiple Conditions

Yes, that is true but it is not the case in your code (that is why I asked if either of the other conditions were arrays).

If you need two arrays, one has to be a vertical array and the other horizontal

Originally Posted by rorya

Yes, that is true but it is not the case in your code (that is why I asked if either of the other conditions were arrays).

No, they are not, but BrandArray is an array as well. It is variant type and contains codes like 1453, 1698, etc. that are matched on.

The column I added to the file has the same kind of format of the column in the code above that is not working (with Array(1, 2, 3, 7, 8, 9, 10))

Originally Posted by rorya

If you need two arrays, one has to be a vertical array and the other horizontal

Sorry, I am confused. Is there some documentation on what kind of rule this is? How would it work for the foo macro? Thank you.

Originally Posted by Dord25

No, they are not, but BrandArray is an array as well.

Yes, I know, but you are not passing the whole array at once as a criterion, you are passing individual elements one at a time using BrandArray(i). Unless the individual elements of your BrandArray array are also themselves arrays, that is not the issue (your code is posted completely out of context so we can't tell).

Sorry, I am confused. Is there some documentation on what kind of rule this is? How would it work for the foo macro? Thank you.

No, because it's not a normal use of countifs. If you use two arrays with the same orientation, the criteria are taken in pairs but what you want is all possible combinations (a Cartesian product). So for example, if you pass the arrays {1,2} and {3,4} as criteria, you would get rows matching 1 and 3, and rows matching 2 and 4 only. You would need the equivalent of {1,2} and {3;4} in formulaic terms.