I would like to set up a cell to calculate the mean of a column using only cells which are greater than or equal to 95% (these cells are results from a calculation). Can this be done?

Sure you can. Let's say your data is in column A1:A100

=AVERAGE(IF($A$1:$A$100=0.95,$A$1:$A$100))

commit with CTRL SHIFT ENTER

It should look like this once committed

{=AVERAGE(IF($A$1:$A$100=0.95,$A$1:$A$100))}


" wrote:


I would like to set up a cell to calculate the mean of a column using
only cells which are greater than or equal to 95% (these cells are
results from a calculation). Can this be done?




--