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 STATUS Combined Sccore
JAN N 31
FEB 31
MAR 25
APR 27
MAY A 27
JUN P 11
JULY P 23
AUG 25
SEP 27
OCT 25


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