To calculate the sum from a group, use the groupsum function.
Syntax: groupsum(range)
groupsum(range)
groupsum automatically skips the value that's being calculated.