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.
brainbursteyeshurt Perhaps not the most elegant solution, but in the attached workbook, you'll find a working example, using some named ranges.