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 ...

In this example, which is based on a list of payroll checks ... them with Excel's wildcard symbols and nested IF statements ...