Craig,
Based on your example data, I expect you want to be able to create a Summary of the averages for EACH hour of the day.
Based on your data, I've developed a model for you that has a separate formula for EACH hour. These formulas are placed on a separate "Summary" sheet.
The formulas use the DAVERAGE function - one of Excel's "database" functions. Others are DSUM, DCOUNTA, etc.
The database functions are QUITE "dynamic" and POWERFUL. Unfortunately, Microsoft has done a less-than-desirable job of documenting this special component of Excel.
The file I've developed for you should serve as an example to get you "jump started" in understanding and utilizing the POWER of these functions.
There's another important aspect of these database functions. The same "criteria" used by the functions can also be used to either:
a) Filter the data in place, or
b) Extract a copy of the data to a separate sheet.
This extraction capability enables one to easily generate "detail" reports to back up the Summary "totals".
This "filtering" can be found on Excel's menu: Data - Filter - Advanced Filter.
So if you'd like me to email you the file, simply email me at my work address below, and I'll send the file.
Please note: I have other example files that demonstrate the capability of the database functions, and VBA code that utilizes the Advanced Filter extraction capability. If you would also like these files, just ask.
This offer (of emailing the files) is also extended to anyone else who would like to "expand your horizons" on this relatively un-tapped but POWERFUL component of Excel.
A final point to "wet the appetite"... Because the Advanced Filter component was developed "internally", it's written in the C language, and is therefore MUCH faster in extracting or filtering data than the conventional looping routines using straight VBA.
Hope this helps
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
