When you're troubleshooting an Excel worksheet, it may help to see the formulas temporarily, instead of the results. With the formulas visible, you can quickly check that the cell references are correct and the formulas are consistent.

Tip: The keyboard shortcut to show or hide the formulas is Ctrl + ' (accent grave, may [...]