However, because you want Excel to count all the animals returned by the UNIQUE function in column ... you can also reference a spilled range in another sheet. For example, to reference a spilled ...