Excel: averaging different cells from specified categories

I want to average cells in different columns which meet a minimum criteria, i.e. > 2.0, from specified categories list in the first column. Example: I want to select a category listed in column A and average the numbers listed in columns C and F for that category which meet a minimum threshold. Thanks

This question generated 26 answers. To proceed to the answers, click here.

This thread is current as of March 17, 2014.

For more resources for Microsoft Excel