An Excel Formula To Count all the Cells with Data in It.

Posted on January 30, 2008
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.

The next Excel Tip and Trick is another very useful one. As I was saying last week to one of our loyal readers (Hi Sandie) that Microsoft Excel is really a great program and I use it for practically anything.

The only possible problem is that it might have too many options. And because of this it might happen that for “simple” tasks you can’t find the right formula. And that’s why I’m here;). Today I want to talk to you about an Excel Tip and Trick that is in line with the formulas that I discussed in the articles to count the empty cells in Excel and the article were we counted all the Excel cells with text in them.

An Excel Tip and Trick to Count All the Cell Containing Data.

In this Excel Tutorial we are using the Excel Function COUNTA.

First you need to place the cursor in Cell B1
Now type in the Formula =COUNTA(A1:A13)
And Press Enter.

Excel-tip-trick-pic1

And that’s it, as you can see it doesn’t have to be difficult.

In this example I also could have sorted the complete row. If you want to count all the Cells with data in the complete row you can use the formula =COUNTA(A:A).

I hope you all liked this Excel Tip and Trick and ill talk to you all tomorrow.

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

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 3 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.