Forum Discussion
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.
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)