Forum Discussion
Sumifs function
Quantity Sold Product 5 Apples 4 Apples 15 Artichokes 3 Artichokes 27 22 Bananas 12 Bananas 61 10 Carrots 33 Carrots Formula Description...
Or a bit shorter:
=SUM(SUMIFS(A2:A9,B2:B9,{"A*";"B*"}))
neat!