=SUMPRODUCT(--(A1:A100="Apple"),--(B1:B10050%),(C1:C100))

"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