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

1 Answer 1


Use a COUNTIF formula.

Cell F2 formula:


Drag it down, done.

enter image description here

  • Thank you. I was over thinking it...lol
    – Von
    Jul 8, 2021 at 18:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.