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

# How to Sum text values like numbers in Numbers

numbers

###### Related Question

- MacOS – The SUM function in Numbers 3.6.1 on the Mac OS X10.10.5 isn’t calculating correctly. Why
- Format values in text cell
- Sum yearly totals automatically
- Numbers Sum of all values in a column where another cell within the row matches text
- MacOS – How to read currency values in Numbers
- Numbers : sum if tick-box on next column is true
- How to import text to columns and import numbers to text in macOS Numbers
- Range of values for a cell in Numbers

## Best Answer

I found some solution now.

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

SOLUTION 2Use Cell "Data Format"

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