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.