How can I translate text values into numbers and sum the result?
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.
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