I am using the following formula to calculate the average daily temperature value in column B (see image below) for each day over a 15-year meteorological record (temperature values are in column B and there are multiple per day). Column A contains the date that the record was taken and column D is a list of unique dates to get the average daily temperatures for.

```
=AVERAGEIFS(R2:R47505,J2:J47505,AN2:AN5965)
```

I would like to replicate this formula for the daily maximum and minimum but do not have `MAXIFS`

or `MINIFS`

formulas in my version of Excel. Is there a workaround to create these formulas?

In the image below, I am trying to calculate the maximum daily temperature in column F; for 01.02.2005, this would be -2.7 for example