Hey All,

Lets say column A is populated with recurring names and column B is populated with numbers. How would I go about counting all the "John Smith" entries in column A which have a number in column B of <=15?

Sumproduct cannot cope with mixed multiple criteria Any alternatives?