Forum Discussion
Thomas_Westerby
Jan 17, 2024Copper Contributor
Automatically summing together groups of numbers in Excel.
Hello, 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...
OliverScheurich
Jan 17, 2024Gold Contributor
=IF(B3="",SUM(INDEX($B$1:B2,LARGE(IF($A$1:A1="",ROW($A$1:A1)),1)+1):INDEX($B$1:B2,ROW())),"")
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.
=HSTACK(TOCOL(UNIQUE(A2:A15),1),BYROW(TOCOL(UNIQUE(A2:A15),1),LAMBDA(x,SUMIFS(B2:B15,A2:A15,x))))
With Office 365 or Excel for the web you can use this formula.