Counting functions in Excel are divided into many types, most of these functions are very easy to use to count cells on a spreadsheet based on different conditions. Below Download.vn will guide you how to use the counting functions: Count, Counta, Countif, Countifs in detail to apply calculations when used.
Instructions for using the count function in Excel
Video tutorial on using Count, Counta, Countif counting functions
Types of counting functions and the meaning of counting functions in Excel
- COUNT: Function to count cells containing numbers
- COUNTA: Function to count non-empty cells
- COUNTIF: Function to count according to a condition
- COUNTIFS: Counting function based on many conditions
How to use the COUNT function
Syntax: =COUNT(value1, value2, ...)
In which: value1, value2, ... are the numeric values that need to be counted.
Example: Calculate the number of cells containing numbers in the table below.
In any cell outside the table, enter the formula: =COUNT(E5:I9)
Immediately after that, the result will be 18 number boxes.
How to use the COUNT function
How to use the COUNTA function
Syntax: =COUNT(value1, value2, ...)
In which: value1, value2, ... are the values to count.
Example: Calculate the number of non-empty cells in the table below.
In any cell outside the table, enter the formula: =COUNTA(E5:I9)
Immediately after that, the result will be 23 cells.
How to use the COUNTA function
How to use the COUNTIF function
Syntax: =COUNTIF(range, criteria)
In there:
- Range: data area to count
- Criteria: conditions for counting.
Example: Count empty cells in the table below
In any cell outside the table, enter the formula: =COUNTIF(E5:I9,"")
Immediately after that, the result will be 2 cells.
How to use the COUNTIF function
How to use the COUNTIFS function
Syntax: COUNTIFS(criteria_range1, range1, [criteria_rang2, range2] …)
In there:
- Range1, Range2: are the data areas to count
- Criteria1, Criteria2: Conditions for counting.
For example: Count the number of people with math scores above 6 and chemistry scores above 9. In any cell outside the table, enter the formula: =COUNTIFS(G5:G9,">6",I5:I9,">=9" )
Immediately after that, the result will be 3 cells.
How to use the COUNTIFS function