How would I work out the average of a range where it has to meet two requirements.

In the example below, I would like to calculate the average 'Score' of all of the 'Type 1' results that are within August 2022.

CodePudding user response：

try:

=AVERAGE(FILTER(C:C; YEAR(A:A)=2022; MONTH(A:A)=8; B:B="Type 1"))

or even AVERAGEIFS can be used

CodePudding user response：

• Fix th date format first there is no August in your dates

To look like this

Try this, or see

To get Unique Names in cell I2

=UNIQUE(D2:D)