Using a hash symbol (#)—also known as a spilled range operator—in an Excel formula ... in your COUNTIF formula in column E, the hedgehog is automatically added to the list in column D, and ...