Extracting Averages

[Bill]

Hi, I have a large excel data worksheet which has the
basic look:

Item: PointA PointB PointC PointD PointE
#01 01-Feb 04-Feb 05-Feb 13-Feb 22-Feb
#02 03-Feb 06-Feb 10-Feb 15-Feb 27-Feb
#03 03-Feb 15-Feb 19-Feb 01-Mar 10-Mar
#04 15-Feb 22-Feb 28-Feb 01-Mar 12-Mar
#05 20-Feb 22-Feb 28-Feb 03-Mar 06-Mar
#06 24-Feb 28-Feb 11-Mar 12-Mar 14-Mar
#07 11-Mar 14-Mar 16-Mar 17-Mar 22-Mar

Its much larger.. but this gives a picture: Also the
dates are dd-mmm-yy and my data sheet contains about 2
years worth of data with more than 700 rows and 25 points
(Columns).
I am looking to evaluate (in days) the AVERAGES between
Points (by month..) to see evaluate the averages related
to the seasons... and place the results on another
worksheet. I am doing this manually... but was hoping
there was a faster way. Currently I am manually
calculating the days between points for each item. Then
sorting point "A" for all of Feb and then calculating the
Average for Feb - March Etc. Thank You in advance for
your time and advice! Bill

 

[Bernard V Liengme]

Hi Bill,
With your first row of data in row 1, dates in B:F, I used
=AVERAGE(C2:F2-B2:E2)
and entered it as an array formula using Shift+Ctrl+Enter. I get 5.25
Have I missed something?
Bernard