Gurus
I have an energy monitor which logs in to Google Spreadsheets and would like to chart Hourly, Daily and Monthly average Energy usage.
I am able to calculate the Monthly average using a formula AVERAGEIFS(B46394:B51316,A46394:A51316,">="&DATE(2018,1,1),A46394:A51316,"<="&DATE(2018,1,31)) for the month of January. This one needs to be hard coded and not automatic or dynamic, I struggled with it and never could generate Daily or hourly averages due to hardcoding the formulas and generating charts as the purpose is not served.
Any idea how I can do this? Thanks in advance.
Kumar
Bookmarks