I have a Google form where multiple people can make multiple entries of data; basically, they are entering volunteer hours for a variety of projects (a bit more complicated than that, but I've got that solved [including creating a new sheet of queried data so calculated fields work]). In the Sheets/Excel doc, I want to add up all of those hours for each individual. I've looked at index/match and vlookup, but I've come up empty. Is there any function that can do this whereby I can create a new column with the the sum of all of the hours logged by each individual?
In the Google file, I want to add all of the merit points for each individual (automatically updated as they add a new form entry).
Solved by B. H. in 12 mins