Excel Forum
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 Magic Trick # 266: Count Words Only w COUNTIF ?*


See that COUNT and COUNTA have trouble counting only words or text. Learn how the simple function COUNTIF with the wildcards? and * will solve this problem.
Also see:
Excel Magic Trick #77: COUNT Vs. COUNTA function

Aladin at the Mr Excel Message Board mrexcel





Got a Question? Ask it Here in the Forum.