Forum Discussion
Solved
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...
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.
Shadysalman Would a regular AVERAGE function not work?
Also the cells are not next to each other, so you cant select them at once, you have to select one by one
Your support is appreciated
Your support is appreciated