With two or more criteria, always think SUMPRODUCT():

=SUMPRODUCT((A1:A100="Apple")*(B1:B100=50%)*(C1:C 100))

--
Gary''s Student - gsnu200812


"Need help with sumif" wrote:

How Do I use SUMIF

A:A = "Apple" and B:B = 50% then sum C:C


Let me know if there is other solution other then SUMIF also