hello, im trying to figure out how i can link data from one sheet to another based on key words and also sum the total number of input data at the same time.
for example, i have a data sheet that people will input their own data in based on, lets say, horseshoe. , Jim, Courtney and Sam are throwing 3 horse shoes each for 3 turns over the course of the next 7 days.
a miss is worth 0, a touch is worth 3 and a hit is worth 6.
i have "point" sheet labeled as %missed, %touched and %hit.
each time a player updates the 'DATA LOG' sheet, the points will be categorized into throw 1, throw 2 and throw 3.
the formula im using is: =SUM(XLOOKUP('DATA LOG'!C2,'DATA LOG'!C2:F10,'DATA LOG'!E:E)) but it is giving me the #VALUE error.
im trying to get the =Sum of (JIMS, Second Throw) to link to the point sheet where i keep track of the percentages. I apologize if im not making much sense.. ive been having a hard time trying to find the right formula. may not even be LOOKUP, but figured it was worth a shot to ask. THANK YOU.
for example, i have a data sheet that people will input their own data in based on, lets say, horseshoe. , Jim, Courtney and Sam are throwing 3 horse shoes each for 3 turns over the course of the next 7 days.
a miss is worth 0, a touch is worth 3 and a hit is worth 6.
i have "point" sheet labeled as %missed, %touched and %hit.
each time a player updates the 'DATA LOG' sheet, the points will be categorized into throw 1, throw 2 and throw 3.
the formula im using is: =SUM(XLOOKUP('DATA LOG'!C2,'DATA LOG'!C2:F10,'DATA LOG'!E:E)) but it is giving me the #VALUE error.
im trying to get the =Sum of (JIMS, Second Throw) to link to the point sheet where i keep track of the percentages. I apologize if im not making much sense.. ive been having a hard time trying to find the right formula. may not even be LOOKUP, but figured it was worth a shot to ask. THANK YOU.
A | B | C | D | E | F |
1 | Date | Name | Throw 1 | Throw 2 | Throw 3 |
2 | 10.15.21 | Jim | 6 | 3 | 3 |
3 | 10.15.21 | Jim | 0 | 0 | 3 |
4 | 10.15.21 | Courtney | 3 | 6 | 0 |
5 | 10.15.21 | Sam | 0 | 0 | 3 |
6 | 10.15.21 | Jim | 3 | 0 | 3 |
7 | 10.15.21 | Courtney | 0 | 3 | 3 |
8 | 10.15.21 | Sam | 6 | 0 | 0 |
9 | 10.15.21 | Sam | 0 | 6 | 3 |
10 | 10.15.21 | Courtney | 0 | 3 | 3 |