SUM multiple criteria

[modene1]

Scenario:
Data: A B
1 x 100
2 y 150
3 z 200
4 a 50
5
6 ("x","a")

I would like a formula that does something like:

sum the values in column B if the values in column A equals ANY of the
values in A6 i.e. A6 is a list or array of criteria. Partial criteria match
would be great too e.g. A3 is replaced with "apple" and A6 contains
(....,"ppl",...)

 

[Jacob Skaria]

With data arrange as below; try this formula

=SUMPRODUCT(SUMIF(A1:A5,"*" & C1:C2 & "*",B1:B5))

Col A Col B Col C
apple 1 app
apple 2 ora
orange 3
mango 4
mango 5


If this post helps click Yes