Forum Discussion

fhceq's avatar
fhceq
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...
  • JMB17's avatar
    Jan 24, 2022

    fhceq 

     

    Another variation I think will work:

     

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

Resources