Excel, Data, Data Analysis, Analytics.
of cells in column B that contain numeric values (scores.) I use this formula: =COUNT(B2:B11) “COUNT” counts cells with numeric values. “B2:B11” specifies the range of cells to examine. This counts the numeric values in column B and gives me the result 7, which is correct. I use the COUNT()