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 ...
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.
Anyways Thank You very much and also to Riny above.