Challenge: fix the broken sales report
25%
SUMAVERAGE
This report has three problems. One is a number stored as text, one is a range that starts a row too low, and one is a figure typed in where a formula should be. Everything you need to find them is in Parts 1 to 12.
The third fault is the interesting one, because right now it is displaying exactly the right number. A hardcoded value is not wrong until the data changes, and then it is wrong silently, forever, and nobody checks it because it was right last time they looked.
Three things in this report are wrong. Fix all three, in B5, D8 and D10.
The grid for this exercise is part of the paid half.
Everything above is yours to read either way. 46 exercises stay free with a profile.