G
Guest
Prolly a simple question.
I need a way to sumif with multiple CHOICES, not criteria.
In other words something like this ..
=sumif(a1:a200,or("Banana","Lemon"),b1:b200)
Id rather not use the formula twice as I am referencing an external workbook
and have many "Fruits" to choose from. The formula essentially becomes too
long if I add up too many "Fruits"
I need a way to sumif with multiple CHOICES, not criteria.
In other words something like this ..
=sumif(a1:a200,or("Banana","Lemon"),b1:b200)
Id rather not use the formula twice as I am referencing an external workbook
and have many "Fruits" to choose from. The formula essentially becomes too
long if I add up too many "Fruits"