Count CF colors

Hi All,

Cross post here: http://www.mrexcel.com/forum/showthr...80#post2860580

I couldn't figure out how to attached a file there, so I came here. I'm in charge of an office football picks pool. I attached my excel file. I used CF to highlight if the person got their pick correct or not. What I wanted to achieve was to count the number of cells that are highlighted green, effectively giving me the total number of picks (or "pts") that each person gets right, but I found out that that would take extensive coding. I know the cells aren't numbers, but is there an easier way to count these? Thanks!

One more update-

So if there a tie, the winner is decided by a tiebreaker. The tiebreaker is being closest to the total score of the last game of the week. You'll see I added a score to the last game at the top, then summed for the total. I added some other columns to try to index-match and output one winner. I wanted to match the high total pts score (12) with the lower number in Col T. You'll see that there are two 12's, matched with a 26 and 7 respectively in Col T. I was trying to output Person7 because they are the winner. Is this possible?

Updated excel sheet attached