Hello, I saw some similar posts but even though the problem is the same, I don't quite get them.
I have a series of products that I want to add together, and this criteria can change. For example:
I would like to add Apples, Pears and Celery, but not Pumpkin. This list has 4 items, but the real one has 50. I'd like to avoid doing a series of sum.if for each individual item, and instead doing something like:
=sum.if(A:A,"apples"or"pears"or"celery", B:B)
It would also be nice to have an option to reference another place that would be great to, for example supposing the list "apples / pears / celery / pumpkin" is in D1:D4:
=sum.if(A:A,D1:D3,B:B)
Are these two options possible somehow?
Thanks!
I have a series of products that I want to add together, and this criteria can change. For example:
Product | Sales period 1 | Sales period 2 |
Apples | 10 | 5 |
Pears | 1 | |
Celery | 9 | 4 |
Pumpkin | 5 | 2 |
I would like to add Apples, Pears and Celery, but not Pumpkin. This list has 4 items, but the real one has 50. I'd like to avoid doing a series of sum.if for each individual item, and instead doing something like:
=sum.if(A:A,"apples"or"pears"or"celery", B:B)
It would also be nice to have an option to reference another place that would be great to, for example supposing the list "apples / pears / celery / pumpkin" is in D1:D4:
=sum.if(A:A,D1:D3,B:B)
Are these two options possible somehow?
Thanks!