Using SUMIFS

[mvpbosfit]

*Please help with SUMIFS coding, total should equal 532,108 lbs.

Using SUMIFS, calculate the total lbs of bananas produced by Ecuador and India.

PRODUCT	COUNTRY OF ORIGIN	LBS PRODUCED 2021
BANANAS	ECUADOR	252,008
BANANAS	PHILIPPINES	522,693
BANANAS	INDIA	280,100
BANANAS	BRAZIL	336,927
COCONUTS	INDONESIA	214,074
COCONUTS	SRI LANKA	509,041
COCONUTS	PHILIPPINES	303,266
MANGOES	MEXICO	526,327
MANGOES	HAITI	216,365
MANGOES	PHILIPPINES	299,419
	TOTAL LBS PRODUCED IN 2021	3,460,220

[#2]

@mvpbosfit 

=SUM(SUMIFS(C2:C11,A2:A11,"Bananas",B2:B11,{"India","Ecuador"}))

This formula returns the intended result in my file.

 

[#3]

If this is a homework assignment, the teacher may be looking for a solution where your formula consists of two SUMIFs added up.