Excel Forum



Excel Name Trick #6: Names COUNTIF & wildcards


See how to use the Names & Wildcards with the COUNTIF function. Search through a list of Addresses and count just the ones on Birch Street. Search through a list of Addresses and count just the ones on the 9000 block of Birch Street.

See the wildcard *
See the wildcard ?

This is a logical (beginning to end) story about most of the use for Excel Names. In this series you will see 12 amazing uses for Excel Names (14 total Name Tricks).





Got a Question? Ask it Here in the Forum.