SUMIF with a wildcard

Premium

In E1, total the sales of every product with Chair anywhere in its name. Use * on both sides of the word: SUMIF(A2:A8,"*Chair*",B2:B8).

E1
ABCDEF
1Product Sales Chair sales
2Office Chair Pro 1450
3Desk Lamp 320
4Kids Chair 480
5Standing Desk 2100
6Chair Cushion 150
7Monitor Arm 640
8Gaming Chair 1890
9

Premium lesson

Unlock SUMIF and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:SUMIFSCOUNTIFS

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?