HomeApplicationOffice information

COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel

The following article introduces you to the COUNTA function - one of the functions in the statistical function group is very popular in Excel.

COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel Picture 1

Description: The function performs counting nonblank cells in the list of arguments.

Syntax: COUNTA (value1, [value2], .)

Inside:

- value1, value2: List of values, cell ranges or references that want to count, where value1 is a required parameter, the remaining value values are arbitrary and contain up to 255 value values .

Attention:

- The function performs counting cells containing any data type except blank cells.

- In case you do not want to count logical values ​​and text or error values ​​-> use the COUNT function .

- To count values ​​that meet certain conditions -> use the COUNTIF or COUNTIFS functions .

For example:

Counts the number of cells containing the data of the cells in the table below:

COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel Picture 2

- In the cell to calculate, enter the formula: = COUNTA (D6: D10)

COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel Picture 3

- Press Enter -> the number of cells containing the data is:

COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel Picture 4

- In the data table on text values, logic is counted, dates are still counted.

- Where the values ​​are blank cells-> functions are ignored:

COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel Picture 5

Above are instructions and some specific examples when using the COUNTA function in Excel.

Good luck!

4 ★ | 2 Vote

You should read it

May be interested

  • Conditional counting function in ExcelConditional counting function in Excel
    conditional counting function in excel. are you looking for conditional counting function in excel to use counting data during data processing in excel spreadsheets? the countif function is a conditional counting function in excel, below is the description, syntax and usage
  • COUNTIF function - Function that counts the number of cells in a data table that meet certain conditions in ExcelCOUNTIF function - Function that counts the number of cells in a data table that meet certain conditions in Excel
    countif function: the function performs counting the number of cells in the data table that meet certain conditions. syntax: countif (range, criteria)
  • Basic Excel functions that anyone must knowBasic Excel functions that anyone must know
    the basic functions in excel such as the excel function, the excel statistics function we summarized below will be very helpful for you who often have to work on excel spreadsheets, especially in the field of accounting. let's refer to offline.
  • How to display function arguments in ExcelHow to display function arguments in Excel
    you often use functions in excel to calculate but there are many less used functions, so you do not remember the argument in the function. you do not need to worry because excel supports the function's display of arguments so that you can use the function as quickly as possible.
  • 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 the COUNT function in ExcelHow to use the COUNT function in Excel
    the count function in excel is the basic counting function that is often used to count how many cells are in an area or in the entire spreadsheet.
  • How to Create a List in Cells in ExcelHow to Create a List in Cells in Excel
    if you want to know how to create a list of multiple lines in a cell on microsoft excel, read this article! whether it's creating a bulleted list with line breaks, a numbered list, or a drop-down list, it's easy once you know where the options are. today's tipsmake will show you three useful ways to insert any kind of list into cells in excel.
  • Instructions to delete blank lines (blank lines) in ExcelInstructions to delete blank lines (blank lines) in Excel
    the data in the excel document file that you are referencing has many blank cells and blank lines that cause the excel file to reverse the data position. you want to delete all the empty cells in that data file but if you delete each cell one by one, it will take a lot of time.
  • 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.
  • VAR function - The function of estimating variance based on a sample in ExcelVAR function - The function of estimating variance based on a sample in Excel
    var function: the function performs an estimate of the latter based on a sample from a given set. function arguments can be numbers, names or arrays, or references containing numbers.

Office information