Thanks for your help, the pivot table worked great. I must have mad a brain
block to not think of that before, I use pivots alot. Thanks again,

Anthony

"Ron Rosenfeld" wrote:

On Mon, 2 Mar 2009 19:38:00 -0800, Shane Devenshire
wrote:

To reach the layout where sum and count are in separate columns you will
need to drag the Data button to the Column area (2003).

I have 2007 and don't have the particulars for earlier version. Thanks for
pointing that out.
--ron