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....
=AVERAGE(IF($D$3:$D$18=D3,$B$3:$B$18))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.