Forum Discussion

Shadysalman's avatar
Shadysalman
Copper Contributor
Feb 18, 2022

Average of cells containing numbers and blanks and text

How to have the average of cells that are mixed with numbers and empty and text to ... So the function only consider numbers and return the average only of the numbers ? Note, the cells are not nex...
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Feb 22, 2022

    Shadysalman Please remove the quotation marks around the percentages as they turn them to texts, no matter what format you have set for the cell.

Resources