Which function counts how many cells in a range contain numbers where value1 value2 and so forth are text numbers or cell references?

The function that counts how many cells in a range contain numbers is the COUNT function. It takes a range of cells as its argument and counts only those cells that contain numeric values. For example, COUNT(A1:A10) will return the number of cells with numeric values within the specified range. Text representations of numbers will also be counted if they are actual numeric values formatted as text.