On Tue, 9 Aug 2005 08:43:03 -0700, "chopsx7"
wrote:

I have numerous lists of data going back several years organized simply col1
- date col2-data. Frequently I need to go back and provide sum totals
(sometimes avg etc) over a requested date range. Is there a way to utilize a
lookup function of some sort whereby I can enter a start and end date and
have excel sum the range based on the dates? Now I manually check the lists
to figure out the range that needs to be included in the calculation.
Thanks

Look at the SUMIF worksheet function:

e.g.:

=SUMIF(col1, "=" & start_date, col2) -
SUMIF(col1, "" & end_date, col2)


--ron