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...
=SUMIF($B$3:$B$7,E3,$C$3:$C$7)
Is this what you are looking for (or do you only want a solution with the offset formula) ?
- Yes, thank you!
