function counts the number of cells that contains numeric value.
Answers
Answered by
4
Answer:
To count the cells with numeric data, we use the formula COUNT(B4:B16). The COUNT function is fully programmed. It counts the number of cells in a range that contain numbers and returns the result as shown above. You may be wondering because B10 contains 345 in the given range.
Explanation:
plz mark me as Brainliest
Answered by
3
Use the COUNT function in a formula to count the number of numeric values in a range. In the above example, A2, A3, and A6 are the only cells that contains numeric values in the range, hence the output is 3. Note: A7 is a time value, but it contains text (a.m.), hence COUNT does not consider it a numerical value.
Similar questions