You Need to Know What the Hash Sign Does in Excel Formulas
Smash the hash in a flash!
Using a hash symbol (#)—also known as a spilled range operator—in an Excel formula is a way to tell the program to consider all results in a spilled range. As a result, even if the spilled range grows or shrinks, the formula containing the # will automatically reflect this change.
