Mean between 2 lookedup values

whitealbum

New Member
Joined
Apr 2, 2019
Messages
5
Hi everyone,

I have a 2 row data set with over 100 cells. The first row contains time values, the second row a numeric value.
I have to find 2 given time values in the first row, and the I need to get the mean between the numeric values under the found values. But here is the tricky part: the mean should not only be based on those 2 found numeric values, but also it should include all numeric values between those 2 values.
i work with live data, so all values can change every day.

I used Hlookup to return the 2 numeric values, but I have no idea how to include all those other numeric values between them...to get the mean.

I hope this challenge can be solved by anyone.

Kind regards
 

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
7,821
Office Version
365
Platform
Windows
Hi. So the average between the two times? Are the times in order?
 

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
7,821
Office Version
365
Platform
Windows
Try this as an example with your times in column A, times in column B and the start time in D2 and end time in E2:

=AVERAGEIFS(B:B,A:A,">="&D2,A:A,"<="&E2)
 

whitealbum

New Member
Joined
Apr 2, 2019
Messages
5
It does return a value, but it is not the mean I am looking for. The mean I got is 1040.
 

Forum statistics

Threads
1,085,047
Messages
5,381,381
Members
401,735
Latest member
ranjithr

Some videos you may like

This Week's Hot Topics

Top