How to Sum text values like numbers in Numbers


enter image description here

How can I translate text values into numbers and sum the result?

Best Answer

I found some solution now.


Use "COUNTIF" function to find the number of cells that match the given text values and then multiply with the reference numbers.

enter image description here


Use Cell "Data Format"

  1. Select some Cell
  2. At the Format Panel > Cell > Data Format
  3. Create a Custom Format.
  4. Select type as "Number"
  5. Add some Rule that you want to format number as text.
  6. Done! You can sum text values like a number now.

enter image description here

You can also see this if you want to use a pop-up menu