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
<tbody>
</tbody>
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 |
<tbody>
</tbody>