Hi
I have a table which allocates a predefined number of points for results scored. Need the points to show in cell G2 using the legend as a score chart.
Thanks in advance.
Hi
I have a table which allocates a predefined number of points for results scored. Need the points to show in cell G2 using the legend as a score chart.
Thanks in advance.
Here:
Formula:=SUMPRODUCT(SUMIF($J$3:$J$7, A2:E2, $K$3:$K$7))
Enter formula in G2 and copy down
Formula:=SUMPRODUCT((A2:E2=J$3:J$7)*K$3:K$7)
Last edited by AlKey; 08-22-2016 at 09:35 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks. Perfect
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks