conditional calculations

J

jenders

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?
 
B

Barb Reinhardt

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))}
 
Top