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...
try:
=SUMIF(B2:B9,"=A*",A2:A9)+SUMIF(B2:B9,"=B*",A2:A9)
HTH
Or a bit shorter:
=SUM(SUMIFS(A2:A9,B2:B9,{"A*";"B*"}))
- neat!