Excel spilled range operator ... from this list later on—you need to add a hash sign after the criteria reference. Instead of typing the formula manually, if you use your mouse to select ...