This has to be a COUNT function but I can't get it right.
I am trying to get a large spreadsheet to tally certain answers across the page. It is bowl games in which each person selected one team or the other my entering the appropriate abbreviation. On the far right I want it to simply count each cell with a correct answer in it. There were 20 games so if the correct answer is in 15 cells then it should total 15. I was able to do it by eliminating the wrong answers and just counting the cells left with info. I would rather do it without having to do this and I know it can be done simply, but not by me! Thanks. Please email suggestions.
Joe Cannata
Bookmarks