Hi I am hoping that someone can help me out, I need Countifs function equivalent for Excel 2002 (XP)... But I also need it to work with counting names, as I have tired to use the sumproduct function but it only like to work with number, I need one that works with names and multiple names at that.. I have a spreadsheet that I need to count how many times two different names are used on said spreadsheet.. I.E. Company 1 + trucks-in = ? Please and thank you