"If" function needed

[Bob]

I would like to send out a auto-fill spreadsheet to all
the participants in a neighborhood football pool. I have
listed all of their picks by game in a spreadsheet and
wanted them to be able to type in the winner of the last
game and have all participants choices be added up at the
bottom of the sheet to show how many correct picks they
have made. Is this possible?

 

[inetuse]

Try this website it has some examples on filtering.

http://www.contextures.com/excelfiles.html#Filter

Hope this helps