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 !)