
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)
