New Member
December 20, 2018
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
VIP
Trusted Members
December 7, 2016
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
1 Guest(s)