Forum Discussion

Copper Contributor

Jan 24, 2022

Solved

Sum by group excel (non-vba nor power query)

Please, I want to sum by group, however I have some conditions. For exemple: I have different fruits divided in groups (1 to 5) in Table 1. In Table 2, I have the quantity of some fruits that are...

excel

Formulas and Functions

JMB17
Jan 24, 2022
fhceq

Another variation I think will work:

=SUM((Table1[Groups]=[@Group])*(Table1[Fruits]=TRANSPOSE(Table2[Fruit]))*TRANSPOSE(Table2[Qty]))
Fruit.xlsx12 KB

JMB17

Bronze Contributor

Jan 24, 2022

fhceq

Another variation I think will work:

=SUM((Table1[Groups]=[@Group])*(Table1[Fruits]=TRANSPOSE(Table2[Fruit]))*TRANSPOSE(Table2[Qty]))

Fruit.xlsx12 KB

fhceq
Copper Contributor
Jan 26, 2022
JMB17, thank you so much!
Your solution helped me a lot!