ExcelBanter - conditional calculations

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - conditional calculations (https://www.excelbanter.com/excel-worksheet-functions/98030-conditional-calculations.html)

[email protected]

conditional calculations

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?

Barb Reinhardt

conditional calculations

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?

--

All times are GMT +1. The time now is 10:24 PM.