Type the formula =Value() and inside the parentheses, type a cell reference that contains text stored as numbers. In this example, it’s cell A2 . Press Enter.

AVERAGEIF and AVERAGEIFS aren't the only functions in Excel that calculate the average of a dataset. For example, the AVERAGE function produces a straightforward arithmetic mean of a set of data, and ...

However, things get a little more intricate if your column contains text entries. If you were to use the above function combination for this, it would only count the rows that feature numbers.

Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.