Most valuable professional
  • Hot Topics

Excel Averageifs formula - can you search for two different criteria in one criteria range

Hi, I am working on spreadsheet in which I have a column of data (combined score) for which I need to find the average off if they match 2 different criteria's (status - A and P)in a different column. Below is an example of the data. Can anyone advise of the formula I keep hitting a brick wall!!! Thanks in advance Month JAN FEB MAR APR MAY JUN JULY AUG SEP OCT

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

This thread is current as of June 11, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel