Can an IF Statement create a cell ignored by AVERAGE?

[Guest]

I have numerical data to plot and compute statistics for. Some data is "out
of range" and should be ignored by the statistical functions and not plotted.
I can address the plotting by making a copy of the data using an IF
statement that returns the value if its in range or #NA if it isn't. The #NA
entries don't plot. However, they do affect functions such as average(),
min(), etc. If I manually go through the list and delete every value that is
out of range, these statistical functions perform as desired. However, I
need to automate that process.

 

[Bernard Liengme]

To compute the average use =AVERAGE(IF(ISNUMBER(A1:A20),A1:A20,"")
and enter it as an array formula using Ctrl+Shift+Enter (not just Enter)
Other function (eg STDEV) can be done in like manner
best wishes

 

[Guest]

Bernard,

Thank you very much!

To compute the average use =AVERAGE(IF(ISNUMBER(A1:A20),A1:A20,"")
and enter it as an array formula using Ctrl+Shift+Enter (not just Enter)
Other function (eg STDEV) can be done in like manner
best wishes