IF text equals yes, 10, maybe, 5, no 0 THEN SUM the same in 2 over columns

Hello,

Hope the title describes what I'm trying to achieve. I had a search if this had already been done but I couldn't find it (probably down to a bad search term).

4 columns where the text value could be either "yes", "Maybe" or "No". Each value then equals a number, so yes=10, maybe=5, no=0. I then want to SUM the values across 3 columns in a row to a total. The table might look like this:

Yes

No

No

Maybe

So in this case the total would be 15.

So far I've got the following:

Please Login or Register  to view this content.

This gets me the value, but Excel doesn't recognize it as a number and when I try to use ISNUMBER, I get an error. I know this is only the start of the statement and doesn't include the SUM part.

Any help would be massively appreciated.

Thanks for looking.

J

Originally Posted by oeldere

=countif($a1:$d1,"yes")*10+countif($a1:$d1,"maybe")*5

and drag down

Worked Thank you, great help and really quick! Appreciate it

J