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