Forum Discussion
Solved
How to calculate average of multiple times for multiple days on a single spreadsheet?
I am a moderately experienced user of Office and Excel but have run against a brick wall with what I am trying to do. In a nutshell, I have a spreadsheet with data from a weather station that has ro...
- Thanks everyone! Got some great ideas but the one I went with used the LET command to setup the details then the AVERAGE/COUNT to get the necessary info I needed. Thanks to all that replied!
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Here is the sample file:
https://1drv.ms/x/s!AtDwlCVLZRa0jGsIeKYc81vEL3bV?e=Dq2nfi
Let me know if you cant access the file. Not sure if I shared this right. I usually don't use OneDrive for anything.
https://1drv.ms/x/s!AtDwlCVLZRa0jGsIeKYc81vEL3bV?e=Dq2nfi
Let me know if you cant access the file. Not sure if I shared this right. I usually don't use OneDrive for anything.
Thanks. See the attached version.
First add headers to your list.
Then add a helper column "Temp >100?" to your data:
=B2>100Use this helper column in the report filter of a pivot table and filter for TRUE.
"Timestamp" in rows area and group by year, month, day.
"Temp" in values area. Change calculation to "Average".
