Task 1 of 4
In E3, count how many items cost more than the threshold in E1. Refer to the threshold by its cell.
Lesson theory
You can build a condition from text and a cell with the & sign:
=COUNTIF(B2:B9,">"&E1) counts values greater than the number in E1. Change E1 and the answer recalculates.Wildcards for text: * stands for any characters, ? for exactly one character.
"Tea*" matches everything that starts with "Tea"; "*coffee*" matches "coffee" anywhere in the text.Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.