ExcelBanter - how do I set up a scoring system in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how do I set up a scoring system in excel (https://www.excelbanter.com/excel-programming/383497-how-do-i-set-up-scoring-system-excel.html)

PaulStoddart

how do I set up a scoring system in excel

i need to set a scoring system, that when a question is answered either Yes
or No it generates a score.

Tom Ogilvy

how do I set up a scoring system in excel

=countif(F:F,"yes")

=countif(F:F,"no")

--
regards,
Tom Ogilvy

"PaulStoddart" wrote:

i need to set a scoring system, that when a question is answered either Yes
or No it generates a score.

All times are GMT +1. The time now is 10:31 AM.