Excel Forum

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.