Hi. I would like to sum all fruits from table like this:
And the result would be:
If I use sumif I only get sum from column fruit 1
Thank you for your help
quantity | fruit 1 | fruit 2 | fruit 3 |
4 | apple | plum | |
3 | pear | apple | strawberry |
8 | apple | ||
6 | strawberry |
And the result would be:
apple | 15 |
plum | 4 |
pear | 3 |
strawberry | 9 |
If I use sumif I only get sum from column fruit 1
Thank you for your help