I have the following in a worksheet:
Daily login
------------
yes
no
yes
yes
no
For every YES I need a score of 5, and for every NO I need a score of -3.
I need to find the sum of all YES and NO in the column. e.g., in the above case, the total is 9 (3 x 5 = 15 for the YESs, plus 2 x -3 = -6 for the NOs). How can I do this with a formula?