You could probably use a pivot table to do what you described. See pivot
table tutorial in Excel.


"ASteele" wrote in message
...
I am trying to create a spreadsheet where I can track test scores for given
tests. I would like to automate, through VBA, the process of doing a
query
for a test between two given dates and producing the overall average for
that
test.

i.e. I may have given a specific test in the month of June 2009. This
test
was given three times, in that month, to a group of 12, 9, and 5
individuals
respectively. I may give several different tests over the course of a
year.
How can I query out a specific test and all the related scores for that
test
between two given dates? Additionally, I need to calculate the average
score
only for the results of the query.