Microsoft Excel Formula to Count all the Cells with Text.

Posted on November 1, 2007 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

Computer Tips, Tricks, Tweaks and Tutorials - Microsoft Excel Formula to Count all the Cells with Text.

A while back I showed you how to create Formula to Count all the Empty Cells. Not only can it be useful to have a little help counting all the empty cells but an Excel Formula to count all the cells that contain Text and numbers can be just as helpful. This very useful Microsoft Excel Tutorial will do that for you.

This is how you use the Excel “Count” and “Counta” function.

We are going to use two Excel functions within this formula. We are using “Count” for all numeric cells and “Counta” for the text cells. 

  • Create some data in Cell A1:A15 and leave some cells blank.
  • Select Cell B1 and type in the formula =COUNTA(A1:A15)-COUNT(A1:A15)
  • Press Enter and you’re done.

Excel Formula Count Cells

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 10 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

2 Responses to “Microsoft Excel Formula to Count all the Cells with Text.”

  1. Rizwan on April 1st, 2008 5:02 am

    I want to know how to count a swlwcted text in MS EXce;. Please reply me as soon as possible so i can continue my work effectively.

  2. Vincent on April 1st, 2008 8:51 am

    First explain to me what is swlwcted and what version are you using?

Leave a Reply