COUNT, COUNTA and COUNTBLANK practice exercises
Count cells: COUNT counts numbers, COUNTA counts anything that is not empty, and COUNTBLANK counts the gaps.
- 1Count numbers with COUNTSome orders have a note instead of a number. In B8, use COUNT to count how many orders in B2:B7 have a number of units.
- 2Count filled-in cells with COUNTAIn E2, use COUNTA to count how many people in B2:B7 have given an email address.
- 3Count empty cells with COUNTBLANKIn E2, use COUNTBLANK to count how many phone numbers are missing in B2:B7.