If you wanted to count the number of entries in a list that contained numbers, text, and blank cells, but ignore the blank cells, which function would you use?
A)COUNT
B)COUNTA
C)COUNTBLANK
D)COUNTIF

Question

Quizplus · Accepted Answer

The COUNTA function counts all non-blank cells in a range, which includes cells containing numbers, text, or formulas. It does not count empty or blank cells. Therefore, the best choice for this scenario is the COUNTA function.

If You Wanted to Count the Number of Entries in a List