Count Function in excel

Here is a quick post explaining the difference between kind of count function present in excel COUNT; COUNTA, COUNTBLANK, COUNTIF, COUNTIFS function?

COUNT

This function counts the number of numeric entries in a list. It will ignore blanks, text and errors.

Syntax : =COUNT(Range1,Range2,Range3... through to Range30)

COUNTA

This function counts the number of numeric or text entries in a list. It will ignore blanks.

Syntax: =COUNTA(Range1,Range2,Range3... through to Range30)

COUNTBLANK

This function counts the number of blank cells in a range.

Syntax: =COUNTBLANK(RangeToTest)

COUNTIF

This function counts the number of items which match criteria set by the user.

Syntax: = COUNTIF (range, criteria)

COUNTIFS

This function counts the number of items which match criteria set by the user. This function can have multiple if a function can be used with criteria based

Syntax: =COUNTIFS (range1, criteria1, [range2], [criteria2], ...)