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.