Thank you. Yes, red, blue, and i in brandarray(i) just represent hard coded numbers to match within the worksheet. They're not arrays.

I can post a workbook but it will take a lot of time to condense the code to the smallest data set possible. Are there any other ideas first to look into? Maybe there is another function I could use that could do the same as Countif in a different way?