DATA ANALYSIS SOFTWARE TRAINING: MICROSOFT EXCEL

MODULE: COUNTING AND CONVERTING IN EXCEL The functions for counting in Excel are mainly:  COUNT   COUNTA  COUNT BLANK  COUNTIF  COUNTIFS For the basics, we will consider using the COUNT, COUNTA, and COUNT BLANK functions.

The COUNT function counts the number of cells in a range that contain numbers. If there are other characters apart from numbers, this function simply ignores them. COUNTA counts non-empty cells in a range. COUNT BLANK counts empty cells in a range.