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.