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