I have a "daily" reporting of a temperature - "daily", yeah, but sometimes I forget it and maybe do the reporting after 2-3 days.




I have to calculate an AVERAGE for each quarter and in fact this average temp.value is what I need to report.


I have made a sample sheet and want ONLY the GREEN columns - the red columns is only here in the sample sheet to illustrate what I mean.


Sorry for the DANISH function names just use translating list for Excel funcions !



When I ENTER the DATE and the TEMP for that day, I want the formula to calculate the AVERAGE TEMP for the QUARTER until "now" (=the date I entered !)

Attached Files

TEST.xlsx (10.9 KB, 11 views)