TCP calculation by member name - baerrach/msf-googlesheet-tools GitHub Wiki
=QUERY('Roster'!A:W, "select SUM(D) where A = '" & A2 & "'", 0)
A2 contains the member name to lookup
| Header Name | Header Column |
|---|---|
| Name | A |
| Power | D |
=QUERY('Roster'!A:W, "select SUM(D) where A = '" & A2 & "'", 0)
A2 contains the member name to lookup
| Header Name | Header Column |
|---|---|
| Name | A |
| Power | D |