Averaging with Address

[chainlink]

I am able to locate a start and end address on another sheet with the ADDRESS and MATCH functions. This is the formula i use for each.

=(ADDRESS(MATCH(A8,'KBOI Data'!A:A,0),MATCH(O$1,'KBOI Data'!$A$7:$N$7,0),1,TRUE,"KBOI Data"))

This returns the address of one end of the the range I want to average 'KBOI Data'!$H$77


But I cannot incorporate these into an AVERAGE function to find the average of the values in the range of the addresses.

Can someone help with this? Maybe give me a better function combination to use to get the averages of values in a table?

Thanks

[NBVC]

If you can give more detail about what you are averaging (i.e. how you want to define the range), then perhaps we can use INDEX() to get the range and then AVERAGE that.

[chainlink]

I have weather data with temperatures I have column labels (degree days) across the top and row labels (dates) along the left side. I am trying to find the average of the values between two dates in a degree day column.

Date 59 60 61 62 63 64 65
2/1/2008 25 26 27 28 29 30 31
2/2/2008 30 31 32 33 34 35 36
2/3/2008 28 29 30 31 32 33 34
2/4/2008 34 35 36 37 38 39 40
2/5/2008 36 37 38 39 40 41 42
2/6/2008 30 31 32 33 34 35 36
2/7/2008 22 23 24 25 26 27 28
2/8/2008 24 25 26 27 28 29 30
2/9/2008 16 17 18 19 20 21 22
2/10/2008 20 21 22 23 24 25 26
2/11/2008 21 22 23 24 25 26 27
2/12/2008 20 21 22 23 24 25 26
2/13/2008 23 24 25 26 27 28 29
2/14/2008 24 25 26 27 28 29 30

So I am trying to get the average of the values between 2/2/2008 and 2/12/2008 in the column with the label 63 for example.

[NBVC]

See attached.

Assuming you have a table in A1:F10 with row 1 having column labels and column A have row labels. And if start/end dates are in I1:I2 and degree-days in I3, then formula would be:

Please Login or Register  to view this content.

Edit: Just noticed your sample set... try to apply to the attached and see if you can adapt it.

[chainlink]

That worked. Thanks!