All the count formula of excel

COUNT() function

The count is used to know how many values are present in the selected cells. COUNT function
only count the numbers. So use COUNT function only in numerical column

Formula:=COUNT(select the range of cells according to your need)

COUNTA() function

The COUNTA is used to know how many values are present in the selected cells. This function counts both text and number. So you can use COUNTA in both numerical and categorical column

Formula: =COUNTA(select the range of cells according to your need)

COUNTBLANK() function

COUNTBLANK shows that how many empty cells are present in selected cells. If you wants to find that how many number of cells which doesn't contain no values then use this function.

Formula: =COUNTBLANK(select the range of cells according to your need)

COUNTIF() function

If you select row or column and then give a value or condition in the COUNTIF function then this the function will count that how many times the condition matched value are present in that selected row or column.

In the function, the first parameter is row or column and the second parameter is the value which count you want to find. Write the value in double cords.

Formula: =COUNTIF(row or column,"Condition")

COUNTFS() function

This function works the same as COUNTIF but here you can use condition more than one. Here multiple conditions is optional.

In the function, the first parameter is row or column, and the second parameter is the value which count you want to find. Write the value inside the double quotation. For each condition do the same thing

Formula: =COUNTIFS(row or column,"Condition",row or column,"Condition",row or column,"Condition"...)