On 9 mar, 00:12, Shaun wrote:
Try this…
This formula will create logic and will assign a value for the equivalent
word.
=IF(A1="two",2,IF(A1="three",3,IF(A1="one",1,)))
A * * * B
1 * * * one * * 1
2 * * * one * * 1
3 * * * two * * 2
4 * * * three * 3
5 * * * two * * 2
6 * * * three * 3

This formula will allow you to sum only corresponding references.
ONE = 2 * =SUMIFS(B1:B7,A1:A7,"one")
Two = 4 * =SUMIFS(B1:B7,A1:A7,"two")
THREE = 6 * =SUMIFS(B1:B7,A1:A7,"three")

Good evening

You can also try the Excel RANK function

Regards