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

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

COUNTA Function in Excel

April 28, 2021 by Andrew Childress
Counta Function Excel

If you have a list of data, it’s often helpful to count the number of cells containing values. Here's how to use the COUNTA function in Excel.

When you have a list of data in a spreadsheet, it’s often helpful to count the number of cells containing values. In other words, you need to know how many cells actually contain data. To do this, you can use the COUNTA function. Let’s learn how to use the COUNTA function in Microsoft Excel.

How to Use COUNTA Function in Excel

Imagine that you have a list of names, and need to record whether each person has responded to a survey. Each participant who responds has “Yes” in the cell beside their names. Those who haven’t responded have a blank cell. You want to quickly count how many people have responded.

Of course, you could perform the count manually. But for a long list of names, that could be a tedious and time-consuming process. Fortunately, Excel offers a quick and easy way to perform the count with a formula.

To get started using the COUNTA formula, click into any empty cell in your workbook. Begin by typing an = sign. This tells Excel that you’ll be inputting a formula into the cell that you’ve selected.

To continue, type in COUNTA, then (. This launches the COUNTA formula. So far, you’ve typed:

=COUNTA(

Counta Excel

Now, it’s time to select the range of cells that you want the function to analyze. In this example, the data range is contained in B2:B6. The easiest way to add this to your formula is to click and drag your cursor to select that range of cells.

Finally, type ). Your full formula reads:

=COUNTA(B2:B6)

Counta Function Excel

Hit Enter on your keyboard, and Excel returns your solution in the cell: 3. This tells you how many cells in the chosen range contain data and values.

Counta formula Excel

As you can see, COUNTA is a quick and easy way to analyze datasets in Microsoft Excel.

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

About Andrew Childress

Previous Post:Sort a list randomly in ExcelSort in Excel
Next Post:Lock Cells in ExcelLock cells in Microsoft Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows 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
  • 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