#219 How do I love thee? Let me count the ways…

Excel has several different methods of counting depending on what it is you want to count. This week, with my sincerest apologies to Elizabeth Barrett Browning, we’ll take a look at those options and show you how to get the results you want.

Understanding the various counting functions in Excel can be a little bit confusing at first. Have no fear, with a little guidance you’ll have it mastered in no time. So fasten your seat belt and enjoy the ride!

Counting How Many Cells Contain Numbers

=COUNT(range)

Counting How Many Cells Are NOT Blank

=COUNTA(range)

Counting How Many Cells Meet A Specified Criteria

=COUNTIF(range,”criteria”)

Counting How Many Cells Are Blank

=COUNTBLANK(range)

Quick & Dirty, No Formula Required Method

The animation below shows how you can use the status bar to get an automatic count with out any formulas at all. Just right click and select Count or Count Nums and the status bar will count the range that is selected in your worksheet.

Feel free to download a copy of this worksheet and play around with it yourself.

Before you get away for the weekend, I just want to say a great big Thank You! to everyone who took the time to weigh-in on what type of tips you’d like to see here. You can check on the results here if you’re curious and I’ll try to start mixing in some new things based on your feedback in the next few weeks.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s