Uses of count function 1.0 COUNTA(range) - when COUNTA() is used, it counts the number of entries on the particular range defined. As long as the cell on the range specified is not emptye.g. Formula is COUNTA(A2:A13), The result would be 12. We have 12 non empty entries on the range
2.0 COUNTIF() - counts the entries on the specified range which satisfies the given conditione.g. Formula is COUNTIF(A2:A13,"Staff"), the result of this is '4'. Where it is specified to count cells with text "Staff" Note : "" (double quotes), denotes that the entry inside is text.
Find attached Sample
