How to count cells in Excel

Too many cells and too many spreadsheets. Sometimes you’ve got to filter cells or cut them entirely to make sense of the overwhelming information that some spreadsheets posses. The best way to do that is to learn how to count cells in Excel.

Looking to become an Excel guru? We’ve covered other Excel how-to topics, like how to subtract in Excel, how to filter in Excel, and how to make a graph in Excel.

But today we’re going to walk you through how to count cells in Excel.

How to count cells in Excel

Step 1. Choose a cell where you wish the following result to appear.

(Image credit: Excel)

Step 2. Hop on over to the Formulas tab and click More Functions.

Step 3. Select Statistical and you’ll get four options: 

COUNTA: Counts cells that are not emptyCOUNT: Counts cells that contain numbers.COUNTBLANK: Counts cells that are blank.COUNTIF: Counts cells that meets a specified criteria.

Step 4. Now type in the range of cells you want included, then click RETURN.

It’s really that simple. You don’t have to juggle the Pythagorean theorem to enjoy the wonders of counting. Don’t go pulling your hair out over Excel. There are plenty of Microsoft Excel tips and tricks to make your life easier.

Back to Ultrabook Laptops

SORT BYPrice (low to high)Price (high to low)Product Name (A to Z)Product Name (Z to A)Retailer name (A to Z)Retailer name (Z to A)

Load more deals


About the Author:

You might like

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.