Forum Discussion

mrn2024's avatar
mrn2024
Copper Contributor
Jan 19, 2024

which function?

Hello,

I'm a basic excel user. 

Could you please help me which function to use and how?

I would like a formula saying apples are 118. 

Could someone help me please?

Thank you.

 

Excel on Mac
Formulas and Functions
  • Mayukh_Bhattacharya's avatar
    Mayukh_Bhattacharya
    Iron Contributor
    Jan 19, 2024

    mrn2024 The easiest way to do this is using Pivot Tables, however using formulas one could use one of the followings:

     

     

    • Using HSTACK() , UNIQUE() & SUMIFS()

     

    =UNIQUE(HSTACK(A1:A4,SUMIFS(B1:B4,A1:A4,A1:A4)))

     

     

    Or,

     

    • Using with GROUPBY() which is applicable to MS365 Insiders Version.

     

     

    =GROUPBY(A1:A4,B1:B4,SUM,,0)

     

     

Resources