Automatically summing together groups of numbers in Excel.

Copper Contributor


I am trying to sum together groups of numbers in Excel based on groupings. 


As in the attached example, certain weights are grouped according to the Shop number. 


Is there a way to use a function to automatically calculate the total of all shops without having to use a formula for each total? 


I am aware of the SUM function and the autosum feature, but these require each total to be calculated separately and individually. 


 I hope my explanation makes sense, thank you :) 

1 Reply




You can apply this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.

sum of groups.png




With Office 365 or Excel for the web you can use this formula.