What does #NAME? mean?

#NAME? is an Excel error message that occurs when Excel does not recognize text in a formula.

This almost always occurs when users have made modifications to the program and have deleted formulas and/or range names, and the integrity of the software has been compromised. The best solution is to start over with a blank template and re-enter your data.