Forum Discussion
summarizing sensor Hourly Data to daily data
I have for each daily date hourly data in the same cell, i.e., the cell contains the date and hour. I am interested in calculating the average daily value from the hourly soil moisture sensor values....
Or use AVERAGEIF.
=AVERAGEIF($D$3:$D$18,D3,$B$3:$B$18)
See attached example, based on that by OliverScheurich
For fun, I used INT instead of ROUNDDOWN and MOD instead of subtracting the date.
Thank you very muchHansVogelaar. It worked.