Count non-empty cells
BeginnerWhen working with data in Excel, you often need to know how many entries you have. The COUNTA function counts how many cells in a range contain data (are not empty). It works like this:
=COUNTA(A1:A5)
This returns the number of cells in A1 through A5 that contain any value, whether numbers, text, or anything else.
Your task
Seven customers were invited to rate a service from 1 to 5, but not everyone responded. Their ratings are in cells B2 through B8.
Use the COUNTA function in cell B10 to count how many customers actually responded.
Note: COUNTA counts any non-empty cell. The regular COUNT function only counts cells that contain numbers. Both would work here, but COUNTA is more versatile since it handles text values too.
Need some help?
Count non-empty cells
BeginnerWhen working with data in Excel, you often need to know how many entries you have. The COUNTA function counts how many cells in a range contain data (are not empty). It works like this:
=COUNTA(A1:A5)
This returns the number of cells in A1 through A5 that contain any value, whether numbers, text, or anything else.
Your task
Seven customers were invited to rate a service from 1 to 5, but not everyone responded. Their ratings are in cells B2 through B8.
Use the COUNTA function in cell B10 to count how many customers actually responded.
Note: COUNTA counts any non-empty cell. The regular COUNT function only counts cells that contain numbers. Both would work here, but COUNTA is more versatile since it handles text values too.