• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Count Numbers in Excel

November 17, 2021 by Andrew Childress

When you work in Excel, it’s often useful to count the number of numerical values within a given range. Here's how to count numbers in Excel.

When you work in Excel, it’s often useful to count the number of numerical values within a given range. If you have a small amount of data, you can do this manually. But it becomes difficult if you have a large volume of data. Fortunately, Excel has a handy built-in function for this purpose. Let’s learn how to count numbers in Microsoft Excel.

How to Count Numbers in Excel

Imagine that you have a range of data contained in cells A1:C5 in your spreadsheet. At a glance, you need to know how many cells contain numerical data. Notice that the range contains three words, so simply counting the number of total cells won’t give you an accurate total.

This is where Excel’s COUNT function comes in. COUNT is the fastest, best way to count numbers in Microsoft Excel. It evaluates a given range and counts only the total numerical values.

To count numbers in Microsoft Excel, begin by clicking into any empty cell in your workbook. Then, type an = sign. This is the universal method for telling Excel that a cell will contain a formula.

Next, type COUNT(, which inserts the COUNT function into your formula, which now reads:

=COUNT(

Count numbers Excel

Finally, you’ll need to select the range from which you want the count of numbers. In this case, the range is A1:C5. Once you have it selected, type ), completing your formula as:

=COUNT(A1:C5)

Hit Enter on your keyboard, and Excel will count the numbers in the range. The solution will display in the cell where you placed the formula: 12.

How to count numbers in Excel

As you can see, it’s easy to count numbers in Microsoft Excel. You don’t have to count manually; instead, by using the simple COUNT function, you can easily evaluate and count within even the largest datasets in mere seconds.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « COUNTBLANK function Excel COUNTBLANK in Excel
Next Post: Angle Clockwise in Excel How to angle counterclockwise in Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top