How to Sum text values like numbers in Numbers?
How can I translate text values into numbers and sum the result?
I found some solution now.
SOLUTION 1
Use "COUNTIF" function to find the number of cells that match the given text values and then multiply with the reference numbers.
SOLUTION 2
Use Cell "Data Format"
- Select some Cell
- At the Format Panel > Cell > Data Format
- Create a Custom Format.
- Select type as "Number"
- Add some Rule that you want to format number as text.
- Done! You can sum text values like a number now.
You can also see this if you want to use a pop-up menu