On the ''Sheet1'' I have hourly values of temperatures, that looks like this:
<tbody>
</tbody>
and that goes till the end of the year.
On the ''Sheet2'' I need to calculate avg, min, max, and at 13:00 hours for each day, so that needs to look like this:
<tbody>
</tbody>
So I've managed to get it for AVG:
Avg = AVERAGEIFS(Sheet1!B;Sheet1!A;">="&DATE(YEAR(Sheet2!A2);MONTH(Sheet2!A2);DAY(Sheet2!A2));Sheet1!A;"<"&DATE(YEAR(Sheet2!A3);MONTH(Sheet2!A3);DAY(Sheet2!A3)))
But I need help with Min, Max and especially at 13:00 hours.
Time | Temp |
1.1.2017 0:00:00 | -5 |
1.1.2017 1:00:00 | -5 |
1.1.2017 2:00:00 | -6 |
1.1.2017 3:00:00 | -6 |
1.1.2017 4:00:00 | -7 |
1.1.2017 5:00:00 | -7 |
1.1.2017 6:00:00 | -7 |
<tbody>
</tbody>
and that goes till the end of the year.
On the ''Sheet2'' I need to calculate avg, min, max, and at 13:00 hours for each day, so that needs to look like this:
Day | Avg | Min | Max | 13:00 |
01.01.2017 | ||||
02.01.2017 | ||||
03.01.2017 | ||||
04.01.2017 |
<tbody>
</tbody>
So I've managed to get it for AVG:
Avg = AVERAGEIFS(Sheet1!B;Sheet1!A;">="&DATE(YEAR(Sheet2!A2);MONTH(Sheet2!A2);DAY(Sheet2!A2));Sheet1!A;"<"&DATE(YEAR(Sheet2!A3);MONTH(Sheet2!A3);DAY(Sheet2!A3)))
But I need help with Min, Max and especially at 13:00 hours.
Last edited: