Conditional averaging

[EGR2317]

Hello again, everyone,

As I delve deeper into this project, I keep noticing things that could be improved.

Attatched is an example of the worksheet that I am working with. On the first sheet, Row 34 gives the option of "OK", "OS", or "HOLD". These options correspond to if the run in question met the criteria. At the end of each row that contains actual data, it takes the average of all of the data. What I would like to do is have only runs that are deemed OK to be included in the average. How would I need to go about doing this?

[DonkeyOte]

There's no data to review but in general given use of XL2007 onwards see the AVERAGEIF function

[EGR2317]

My mistake. Here is a version with data in row 20 that is averaged. I have given the Row 34 classifications based on the sample data.

[DonkeyOte]

as mentioned:

=AVERAGEIF($G$34:$AH$34,"OK",$G20:$AH20)

[EGR2317]

Thank you very much