I need to find the number of occurrences in a column where criteria in three other columns (same row) are met. There are also a lot of duplicates I need to exclude. This is why I am using a dictionary. All of the passed ranges (columns) are the same length, vary up 30,000 rows, and exclude the header. The Filters I am passing are the criteria and are supplied when calling the function. There are two sheets – sheet and pSheet. I am expecting a result from the function, but it constantly returns nothing. There should be multiple items in the dictionary.