The only drawback to using this is that if you don't have any data for the day you get a #DIV/0! error in the cell. If I only knew how to fix that....
In Excel, you can use IFERROR to tell it what to do when there is an error
=IFERROR(AVERAGEIF(C2:C10029,">="&(TODAY()),D210029),"No Data")
In Excel, you can use IFERROR to tell it what to do when there is an error
=IFERROR(AVERAGEIF(C2:C10029,">="&(TODAY()),D210029),"No Data")
Last edited: