Count with a wildcard

Premium

In D1, count the products in A2:A8 with the word Chair anywhere in the name. * stands for any text, so the criterion is "*Chair*".

D1
ABCDEF
1Product Chairs
2Office Chair Pro
3Desk Lamp
4Kids Chair
5Standing Desk
6Chair Cushion
7Monitor Arm
8Gaming Chair
9

Premium lesson

Unlock COUNTIF 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:SUMIFSUMIFS

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?