Forum Discussion
Assign a number to a performance word and total a row range
Sorry about the cumbersome title i've got a blinding headache spending hours staring at a computer screen to work out the solution myself to no avail, i can barely think straight now. All i want to ...
So sorry i told you i wasn't thinking straight. In the cells of the row with the Athlete Name, i have, instead of the numbers, E, VG, G, A, P, so i wish those letters to DISPLAY, but in the last cell the number total to display.
Please note the examples above is a a rough one to 'try' and get across what i wish to do, it's not my actual document. However the query will help out anyone who wishes to assign a number to a word or any text statement, and then use the SUM in many ways.
Please note the examples above is a a rough one to 'try' and get across what i wish to do, it's not my actual document. However the query will help out anyone who wishes to assign a number to a word or any text statement, and then use the SUM in many ways.
Perhaps, this formula in F2 in the snapshot below satisfies your requirement:
=SUMPRODUCT(LOOKUP(A2:E2,
{"A","E","G","P","VG"},
{2,5,3,1,4}))When copied down rows, the results will look like these:
You may play with the formula in the attached file.
- Huge apologies, as it seems i didn't reply and offer thanks for this at the time. I may have at the time settled on either a non-optimal alternative solution for speed or, using your example, as i came upon a glitch, something similar but certainly helped by your example.
Anyways Thank You very much and also to Riny above.