Forum Discussion
Solved
Find the sum of values found with offset function
Hi! I cant figure out a solution for this one on my own. On the table on the let, there are fruits that appear multiple times. I would like to get the sum of the amounts to the right. So wha...
As variant
by
=LET(
fruit, $B$3:$B$7,
amount, $C$3:$C$7,
u, SORT( UNIQUE( fruit ) ),
isFruit, --( u = TRANSPOSE( fruit ) ),
CHOOSE( {1,2}, u, MMULT( isFruit, amount ) ) )
Oh thats interesting too, thanks!