Link to home
Start Free TrialLog in
Avatar of vegas86
vegas86

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Michael Fowler
Michael Fowler
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vegas86
vegas86

ASKER

thanks Michael, works perfectly!!