How do you average between specific intervals?

[ME08JR]

Hi,

I have a large amount of data that I require averaged between specific intervals, all 1m lengths.

An example of data is below:

A B
1.3 1
1.5 2
1.6 2
2 1
2.1 2
2.4 1
2.8 1
3.3 2
3.9 2


I want to display the results as:

From To Average
1 2 1.666666667
2 3 1.25
3 4 2

Any help would be greatly appreciated!

[jeffreybrown]

How about

=AVERAGEIFS($B$2:$B$10,$A$2:$A$10,">="&D1,$A$2:$A$10,"<"&E1)

      D E -----F-----
  1   1 2 1.666666667
  2   2 3    1.25    
  3   3 4      2

[ME08JR]

Perfect! Cheers that's saved a lot of time!

[jeffreybrown]

You're welcome. Glad it worked for you and thanks for the feedback

Please don't forget to mark the thread as solved if the solution(s) provided answers your query.