Embedded Files
About COUNT Function?
In Excel, the COUNT function is used to count the number of cells contains number only in a specified range.
For Correct Data Refer Image-2
About COUNTA Function?
In Excel, the COUNTA function is used to count the number of non empty cells in a specified range including Text / Space & Numbers.
About COUNTBLANK Function?
In Excel, the COUNTBLANK function is used to count the number of empty cells in a specified range.
Common Mistakes to Avoid
Do not type space in blank cell because this formula don't count space as blank.
Google Sites
Report abuse