FormuladrillA count that ignores its threshold
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
This sheet counts the scores above and at or below the threshold in E1. The numbers are right today, but when Nadia changed the threshold one of the two counts did not move. Find the formula that ignores E1 and fix it.
What this exercise teaches
A criteria string such as ">80" freezes the number inside the formula. ">"&E1 builds the same text from the cell, so the count follows the threshold. That is why the checker also runs the sheet with a different threshold.
A hint if you get stuck
Open each COUNTIF and look at the criteria. One has the threshold typed inside the quotes instead of joined to E1.
Try it now, free, no account needed
The first 15 tasks on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro adds timed mode and the certificate.
Open this exerciseMore exercises in Find the error
- The budget that looks fineFree
- A rate typed into a formulaFree
- Commission copied downPro
- Growth that does not add upPro
- The wrong price columnPro
- An average with the wrong countPro
- A region total that misses a rowPro
- A loan payment that is far too highPro
- Variance with the wrong signPro
- The lookup without FALSEPro
- An NPV discounted one year too manyPro