214k views
4 votes
You would like to know how many cells contain data. Which function should you use?

A. COUNT
B. MIN
C. SUM
D. ABS

1 Answer

6 votes
If we're talking about excel functions, A is your answer.

The COUNT function does exactly that (with modifications of it counting specific things e.g. COUNTA, COUNTIF, etc)

MIN returns the minimum value in the selected range.
SUM returns the sum of the values in the selected range.
ABS returns the absolute value of the selected cell.