excel numeric value for text in a cell

Can someone help me with a formula to assign a numeric value for a text cell, then total the number at the end of the row?

Y=1, then add all the 1's in the row. I am trying to get total number of certifications per employee

example of worksheet


Solution 1:

Use a COUNTIF formula.

Cell F2 formula:

=COUNTIF(B2:E2,"Y")

Drag it down, done.

enter image description here