Which of the following is a differentiation between calculating using the functions COUNT and COUNTIF?
A)COUNT does not require a range of cells; COUNTIF requires a range of cells.
B)COUNT can be obtained without a special criteria, COUNTIF requires range and special criteria to be calculated.
C)COUNT requires a range of cells; COUNTIF does not require a range of cells, only special criteria.
D)COUNT calculates the sum of values for a range of cells; COUNTIF finds the largest value in a range of cells.

Question

Quizplus · Accepted Answer

The differentiation between COUNT and COUNTIF is that COUNT calculates the total number of cells in a range that contain a numerical value, whereas COUNTIF requires a range and a specific criteria to count (e.g. count all cells that contain a value greater than 5). Therefore, option B is the correct differentiation between the two functions.

Which of the Following Is a Differentiation Between Calculating Using