The COUNTA function, how to use the function to count cells containing data in Excel

Besides calculating values ​​in Excel, the use of Excel functions to count cells with any value, or with values, also often occurs. Previously, Network Administrator instructed you to read how to use the COUNT function to count cells with data. So what if you want to count cells containing data and data on Excel? The COUNTA function in Excel is used to count cells in a given area that contain data, counting non-empty cells that contain data. This counting function does not distinguish the numeric data type or the text format in the data area or in a value set, such as number, date and time, text value, . The following article will guide you how to read Use the COUNTA function in Excel.

  1. How to combine 2 columns Full name in Excel does not lose content

  2. Instructions for separating column content in Excel
  3. How to hide, show notes in tables on Excel
  4. How to create flashing letters on Excel

The video tutorial uses the COUNTA function in Excel

How to count the number of cells that contain data in Excel

The COUNTA function in Excel has the COUNTA function formula (value1, [value2], .) .

In which value 1, value 2 is a list of values, cell ranges or references that want to count numbers. Value 1 is the required parameter and the remaining value values ​​are optional, containing up to 255 vaue values.

Attention:

  1. The function performs the count of cells containing any data type except the blank.
  2. If you don't want to count logic and text values ​​or error values, use the COUNT counting function.
  3. To count values ​​that meet certain conditions, use the COUNTIF or COUNTIFS functions.

For example, the COUNTA function counts Excel cells in a range

For example, with data tables with different values, use the COUNTA function to count the number of cells that contain data in the table.

The COUNTA function, how to use the function to count cells containing data in Excel Picture 1

At the result of the Value box, enter the formula = COUNTA (C2: C7) and press Enter.

The COUNTA function, how to use the function to count cells containing data in Excel Picture 2

The result 6 shows that there are 6 cells containing data in the Value column, regardless of the values ​​in the box including text, date.

The COUNTA function, how to use the function to count cells containing data in Excel Picture 3

If you delete data in any cell, the number of automatic result cells decreases. Then the COUNTA function will automatically ignore those spaces.

The COUNTA function, how to use the function to count cells containing data in Excel Picture 4

The COUNTA function example counts Excel cells in multiple ranges

For cell counting exercises in many Excel ranges, COUNTA still counts exactly as if counting cells in a range. We have Excel file with 2 data tables as below. Counts the number of cells that contain data in the Value column.

The COUNTA function, how to use the function to count cells containing data in Excel Picture 5

In the input field, enter the number of non-empty cells, enter the formula = COUNTA (C2: C5, C8: C12) and press Enter. Where C2: C5 is the first data area that wants to count the number of cells and C8: C12 is the second data area to count the number of cells.

The COUNTA function, how to use the function to count cells containing data in Excel Picture 6

The display results 6 means that the total number of cells that contain data on both data tables within the Value column is 6. Even if you count the number of cells on multiple ranges, the COUNTA function is also automatically ignored. Empty cells and only include cells containing data regardless of the type of data.

The COUNTA function, how to use the function to count cells containing data in Excel Picture 7

So using the COUNTA function to count the number of cells containing Excel data is very simple and quick to manipulate. You can use functions to count non-empty cells in a range or different ranges. Counted figures are not distinguished from empty cells.

I wish you all success!

4 ★ | 1 Vote

May be interested

  • Count function in excel, formula, how to use count function in most detailCount function in excel, formula, how to use count function in most detail
    in excel, the count function is a powerful tool that helps you quickly count numeric values ​​in a spreadsheet. whether you are new or familiar with excel, mastering the syntax and usage will make calculations easier. let's explore the details in the article below.
  • Instructions for using the COUNTBLANK function in ExcelInstructions for using the COUNTBLANK function in Excel
    in excel, the countblank function helps users count the number of blank cells in a given data range. this function is useful in checking for missing data, processing reports and statistics. this article will guide you in detail on how to use countblank, with practical examples.
  • Cell counting function with data in Excel - Enclose exampleCell counting function with data in Excel - Enclose example
    the function to count cells with data in excel. in excel supports the data counting function to help you summarize the fastest way. the following article introduces data counting functions in excel.
  • How to use the COUNTIFS function in ExcelHow to use the COUNTIFS function in Excel
    the countifs function in excel is a useful tool that helps you count the number of cells that satisfy various conditions. when working with large data, this function helps to make quick and accurate statistics. the following article will guide you on how to use countifs and provide specific illustrative examples.
  • DCOUNT function in Excel - Usage and practical examplesDCOUNT function in Excel - Usage and practical examples
    the dcounta function is one of many frequently used math functions in excel. the dcount function helps you count non-blank data cells in list columns or data arrays with defined conditions.
  • How to use DCOUNT function on ExcelHow to use DCOUNT function on Excel
    the dcount function on excel is used to count the number of cells that contain numeric data with given conditions.
  • How to count characters in ExcelHow to count characters in Excel
    to count characters in excel we need the help of the len function. the len function helps you count the number of characters including spaces in a given phrase. normally, the len function is not used alone, it will combine with other functions based on certain purposes.
  • COUNT function in SQL ServerCOUNT function in SQL Server
    this article will show you in detail how to use functions that handle count () numbers in sql server with specific syntax and examples to better visualize and capture functions.
  • Merge cells in ExcelMerge cells in Excel
    the most common reason to merge cells is to format and center headers. this tutorial will show you how to merge cells in excel, although you shouldn't merge them unless you really need to.
  • How to use the SUMIF function in ExcelHow to use the SUMIF function in Excel
    the sumif function in excel is a function used to compute values ​​in a specified range. the sumif function can be used for summing cells based on the date, data and text that are connected to the specified area.