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.
Thanks for spending the time.
I just doubled check all the cells I have linked to the outcome cell, and all of them are percentage type not text. however it worth mentioning that all the cells have predefined formula that return the result in each of them.
See the attached for illustration.
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.
- Much appreciated for the solution, was simple one, but seems i need to understand formulas more