COUNT cells in MS Excel

Here I have described all the types of COUNT formulas in MS Excel.......

COUNT(range):

    This function is used to count the number of cells in the given range which contain numbers in it.

COUNT(A1:A10) = 5

COUNTA(range):

    This function is used to count the number of cells in the given range that are not empty.

COUNTA(A1:A10) = 8

COUNTBLANK(range):

    This function is used to count the number of cells in the given range that are empty.

COUNTBLANK(A1:A10) = 2

COUNTIF(range, criteria):

    This function is used to count the number of cells in the given range that match the given condition or criteria.

1)

COUNTIF(A1:A10,"") = 2

 2)

COUNTIF(A1:A10,"=D") = 1

 3)

COUNTIF(A1:A10,"<>D") = 9

 4)

COUNTIF(A1:A10,"<3") = 2

COUNTIFS(range1, criteria1, range2, criteria2,.....):

    This function is used to count the number of cells in the given ranges that match the given conditions.

Note: In all the given ranges & conditions, the minimum count will be taken.....

COUNTIFS(A1:A5, "<3", A6:A10, "<>") = minimum(2,4) = 2

Extras:

"" - blank

"<>" - not equal to blank

" " - contains 'single space'

Thanks for visiting.......!

If u r in need of any projects, you can contact me via gopi21uk@gmail.com
Areas: DOT NET, SQL, HTML, Data Entry, Excel, etc