CODEWITHSUNDEEP
excelreference
user2994092
user2994092

Reputation: 1

Excel- using letter codes to replace a number

Im trying to use the SUM function to add up a combination of values however i need these values to be represented as letters.

Example

_ A
1 dh
2 ak
3 fg

i have the values i want dh, ak, and fg in another column i want the sum to go through column a and whenever it comes to the letters it replaces them with the number in the corresponding values.

Thanks in Advance

Upvotes: 0

Views: 133

Answers (1)

Nathan Fisher
Nathan Fisher

Reputation: 7941

I hope I am understanding what you're after but I would be using the VLookup function in a separate column then run the sum over the calculated column.

I assume that there is another set of values that the numbers/letters refer to, that these calculations will be based on?

Upvotes: 1

Related Questions