I am using a formula to sum the values in the column if it matches a certain criteria but it is not giving the answer I want. Could you help me figure out what I'm doing wrong? I have a table named Prod with columns labeled Tag and Group. Here is the formula I have in B20: =SUM(SUMIF($A$3:$A$10,INDEX(Prod[Tag],AGGREGATE(15,6,1/(Prod[Group]=A20)*ROW(Prod[Group]),ROW(INDEX($A:$A,1):INDEX($A:$A,COUNT(1/(Prod[Group]=A20)*ROW(Prod[Group])))))),$B$3:$B$10))
help 1.png The table written in red is my desired outcome.
Help 2.png Here is the table of how I want to seperate my data. It is in a seperate sheet.
Bookmarks