Excel Forum
Similar Content
Easy Way to Manage Names in Excel
Tutorial: How to manage Names in Excel so they are easy to view and change as needed. This is a li...
6 Tricks to Make Dates Work in Excel
Tutorial: Watch this tutorial if you work with dates! Quick and easy ways to reliably convert dates...
MODE() - Find Most Repeated Value in a List in Excel
Tutorial: The MODE() function in Excel allows you to quickly find the most repeated or frequently oc...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.