Alternative formula
=AVERAGE(INDEX(B2:F30,MATCH(H1,$A$2:$A$30,0),1):IN DEX(B2:F30,MATCH(I1,$A$2:$A$30,0),5))

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"len c" wrote in message
...
Thank you Bernard.

I would to take things one stage furtherif possible : by only ever
entering
start and end dates in blank cells on a different page I would like excel
to
associate each of those dates ( which are anything from two weeks to 6
months
apart) with a ROW and, then using that ROW number start to "SUM" and/or
"AVERAGE" all the information between those rows in the specified columns
on
the worksheet. i.e if "MATCH" identifies row 22 ( by date input), how do
I
get excel to take this number (22) and add it to a column to genertate a
Cell Reference to use within a SUM/AVERAGE calculation?

This would save me having to do everything manually everytime a report is
needed.



"Bernard Liengme" wrote:

I have headings (labels) in row 1 (Date, A,B,C,D,E)
In A2:30 I have dates
In B2:F30 I have numeric values
In H1 I have a start date, in I1 an end date
In J1 I used
=SUMPRODUCT((A2:A30=H1)*(A2:A30<=I1)*B2:F30)/(SUMPRODUCT((A2:A30=H1)*(A2:A30<=I1))*5)
to find the average of the values.
The = and <= means I include both dates.
For more on SUMPRODUCT see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Len C" <Len wrote in message
...
I have a worksheet with consecutive dates in column A and blood glucose
figures across the page in 5 columns. I wish to be able to enter start
and
finish dates and automatically find those dates and calulate the
averages
betwen dates. I can find the ROW by using "Match" but don't know how to
use
this info to identify the columns I wish to "AVERAGE" or "SUM". All
help
appreciated