MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How To Assign a Value To a Word or Letter In Numbers?

How do I assign a value to a word or letter in Numbers
example: Yes or Y has a value and No or N has a value.
then to add a chart bar/ Pie chart showing Yes and No
—–
David

Comments: One Response to “How To Assign a Value To a Word or Letter In Numbers?”

    4 years ago

    Are you looking to count them? Or do you want to assign a specific value, like Yes = 37 and No = 14?

    I'll assume you want to count them. You just use the COUNTIF function for that. See https://macmost.com/counting-items-with-numbers.html

    So if you are using a mix of "Yes" and "Y" then you can use something like this to count them both in column B:
    COUNTIF(B,"Yes")+COUNTIF(B,"Y")

Comments Closed.