You would like to know how many cells contain data. Which function should you use?

Responses

MIN
MIN

SUM
SUM

COUNT
COUNT

ABS
ABS

1 answer

To determine how many cells contain data, you should use the COUNT function.

The COUNT function counts the number of cells that contain numeric data in a given range. If you want to count all non-empty cells (including text), you can use the COUNTA function.

However, based on the options provided, COUNT is the correct choice.