bob777 wrote in
:


Hi,
I suggest you abandon the pivot table and use the sumproduct function.

Then you can put the names of the players in col A, put your required
dates in 2 convenient cells, and then use sumproduct to extract the
total scores achieved by each player within your date ranges.

In a separate table, use countif to count the NUMBER of scores within
the date range, and then finally print the averages in a separate
table. If you are happy to publish your e-mail address, I will send
you a simple spreadsheet demonstrating this.


I considered this (and may still do something like that if I can't find
the proper solution with the pivot tables), but the pivot tables have
several advantages that I really like -- Players will be able to double
click on their score summary in the table to drill down to the data of
their actual games (which show a lot more detail than the pivot table
provides). Also, if I was able to implement the table the way I want, a
player could decide to check their scores for games played on Mondays
(by checking just those days from the drop-down box) and then comparing
these scores to games played on Fridays.

Most of the people who will be using the tool are familiar with Pivot
Tables (reading them, not creating them), so although designing my own
tool to extract the desired data is probably feasible, it's not ideal.


--
Marc.