Should not contain spaces ( ) or other punctuation marks. Should be 1-250 characters long. Should not tally with the range itself. If you try to name the range asA1:B2, the errors may occur. If something goes wrong, e.g. you use space in the nameTotal Sales, you'll get an error...