Mean between 2 lookedup values

[whitealbum]

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]

Hi. So the average between the two times? Are the times in order?

 

[whitealbum]

Hi. So the average between the two times? Are the times in order?

Yes, the times are chronologically in order. The numeric values not.
I need the average of the 2 returned numeric values, including the numbers in between them.

 

[steve the fish]

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]

It does return a value, but it is not the mean I am looking for. The mean I got is 1040.

 

[whitealbum]

It does return a value, but it is not the mean I am looking for. The mean I got is 1040.

https://i.postimg.cc/g243KsrN/Naamloos.png

 

[whitealbum]

I made a small typing misstake. I have got what I need. Thank you very much!