Error: #NAME?

Why: #NAME? errors happen when you accidentally type in the wrong name of a formula or range/cell name.

Example: Summ(A1:A3) will return the #NAME? error because "Summ" should be "Sum." Another example would be if the table was named
"Taxes" and then was referenced as "Taxe." Since they're not the same, an error would appear.

Solution: Verify all the typed text is correct.