Exercises / Conditional counting and sums · 9 of 11
Count products that contain a word
In COUNTIF and SUMIF criteria, * stands for any text and ? for one character. "*pro*" matches anything that contains "pro". With a cell: "*"&F1&"*".
Your taskIn F2, use COUNTIF to count the products in A2:A11 whose name contains the word in F1 anywhere.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Product | Price | Search | Pro | ||
| 2 | Laptop Pro 14 | $1,899.00 | Matches | |||
| 3 | Laptop Air | $1,199.00 | ||||
| 4 | Tablet Mini | $499.00 | ||||
| 5 | Pro Stylus | $129.00 | ||||
| 6 | Phone Pro Max | $1,299.00 | ||||
| 7 | Earbuds | $179.00 | ||||
| 8 | Tablet Pro | $1,099.00 | ||||
| 9 | Phone Mini | $699.00 | ||||
| 10 | Monitor | $399.00 | ||||
| 11 | Keyboard Pro | $149.00 |