SUMPRODUCT IF(OR) type of thing

Hello, I need to sum the product of 2 columns, if their value in another column meets a certain criteria.

Col A...........Colum B.........Col C
Apples..........5..................12
Bananas.......6...................44
Cherries........10..................33
Apples..........5.......................7
Apples.........4......................36
Bananas.........6.....................3
Cherries.........3.....................0

I would like to sumproduct Colum B * Col C if Col A = "Apples" or "Cherries"


=SUMPRODUCT(--(A1:A100=OR("Apples", "Cherries"),B1:B100,C1:C100) does not seem to work.

Try it like this...

=SUMPRODUCT(--ISNUMBER(MATCH(A1:A100,{"Apples","Cherries"},0)),B1:B100,C1:C100)

Try this
Cells F1 and G1 hold "Apples" and "Cherries" respectively with formula entered in F2

Formula:

Please Login or Register  to view this content.

v	A	B	C	D	E	F	G
1	Apples	5	12			Apples	Cherries
2	Bananas	6	44			115
3	Cherries	10	33
4	Apples	5	7
5	Apples	4	36
6	Bananas	6	3
7	Cherries	3	0

Or this

Formula:

Please Login or Register  to view this content.

Not quite sure which options OP want.

You're welcome!