Log In
Register
Home
New Member
December 20, 2018
Offline
Hello. I need to average multiple data points from a 24-hour period into a daily average. The averageifs function I used =AVERAGEIFS(E$2:E$584,$A$2:$A$584,">=$J2",$A$2:$A$584,"<$J3") returns #DIV/0! Is there a way to do this? These are just a few of the parameters - there are many more and the averaging will need to be done for the year. The number of data points per day vary for each variable - some days / variables have one data point and other days / variables have several. Is AVERAGEIFS the correct function to use? Ideally, I'd like to put the daily averages in another sheet to analyze the data separately.
Thanks!
Laura
See Answer
VIP
Trusted Members
December 7, 2016
Offline
Hello Laura,
Welcome to this forum, I am pretty sure you will finf it resourceful.
Try changing your formula a bit. As I am currently using a tablet I have not been able to check your file in detail, but Iet's see if the changes helps you out.
=AVERAGEIFS(E$2:E$584,$A$2:$A$584,">="&$J2,$A$2:$A$584,"<"&$J3)
Answers Post
New Member
December 20, 2018
Offline
Hello Anders - that did the trick. Thank you! AVERAGEIFS will be a very helpful tool in data analysis. The next step will be data cleansing of the averages. That part may take longer as I'll have to get a bunch of engineers to agree on methodology :).
1 Guest(s)
