Counting data
BeginnerWhen working with data in Excel, you often need to know how many entries you have. This is where counting functions come in handy.
The COUNTA function counts how many cells in a range contain data (are not empty). It's perfect for counting survey responses, attendance, or any other list where some entries might be missing.
The COUNTA function looks like this:
=COUNTA(A1, A2, A3)
Or using a range:
=COUNTA(A1:A5)
This will count how many cells in the range A1 through A5 contain any value (numbers, text, or anything else).
Your task:
In this exercise, we have a customer satisfaction survey. Seven customers were invited to rate our service from 1 to 5, but not everyone responded. You can see their ratings in cells B2 through B8.
Use the COUNTA function in cell B10 to count how many customers actually responded to the survey.
Note: We use COUNTA instead of COUNT because COUNTA counts any non-empty cell. The regular COUNT function only counts cells with numbers, which would work here too, but COUNTA is more versatile.
Need some help?
Answer
Exercise
Counting data
BeginnerWhen working with data in Excel, you often need to know how many entries you have. This is where counting functions come in handy.
The COUNTA function counts how many cells in a range contain data (are not empty). It's perfect for counting survey responses, attendance, or any other list where some entries might be missing.
The COUNTA function looks like this:
=COUNTA(A1, A2, A3)
Or using a range:
=COUNTA(A1:A5)
This will count how many cells in the range A1 through A5 contain any value (numbers, text, or anything else).
Your task:
In this exercise, we have a customer satisfaction survey. Seven customers were invited to rate our service from 1 to 5, but not everyone responded. You can see their ratings in cells B2 through B8.
Use the COUNTA function in cell B10 to count how many customers actually responded to the survey.
Note: We use COUNTA instead of COUNT because COUNTA counts any non-empty cell. The regular COUNT function only counts cells with numbers, which would work here too, but COUNTA is more versatile.