On Wed, 18 Feb 2009 22:00:01 -0800, ryguy7272
wrote:

Beeeeeee-uuu-teeee-fuullllllll..... You know what Dick, I tried so many
combinations of functions, including a susbtotal for each rep, and
subtracting out amounts that didn't match...all sorts of things. Nothing I
did seemed to work (although I had one false alarm), but you found the secret
formula!!


You're welcome. It was the SQL statement that finally turned on the light
bulb. I should make a utility that spits out a SUMPRODUCT formula when you
enter a SQL statement. :) Sounds hard.
--
Dick