Formula help

Hello,

Can someone please help me with the following?

I am after a formula that counts the number of ticks and then works out a rating.

On the attached I have ticks in columns A through to E in column F I would like to add the number of ticks and then put a number according to the ratings range below,

How would I do this?

example.xlsx
vegas86Asked:
Who is Participating?
 
Michael FowlerConnect With a Mentor Solutions ConsultantCommented:
Here is one for row 3

=IF(COUNTIF(A2:E2,"P")=5,1,IF(COUNTIF(A2:E2,"P")=4,2,IF(COUNTIF(A2:E2,"P")=3,3,IF(COUNTIF(A2:E2,"P")=2,4,5))))

Michael
example.xlsx
0
 
vegas86Author Commented:
thanks Michael, works perfectly!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.