Let me start by saying I'm an Excel Novice. I'm looking for help with this formula: =COUNTIFS('Test Points'!F2:S2,">0",['Plyr of Yr'!B2:B160,"Smith, John"]). I'm trying to count (in as different worksheet) the number of times a number greater than zero appears in cells F2 thru S2 and match the name of Smith, John in cells B2 thru B160. I would also like to copy this formula so the name changes. Thank you in advance.