I see what you want.
I'm in Xl 2002 and it does exactly what you want (as you already know).
Sorry, I can't help with the 2003 version ... I suppose MS would call it an
enhancement :(
Maybe a table using DAverage & DCount instead.
Good Luck.

Rgds,
ScottO

"KipNowlin" wrote in message
...
| Scott...
|
| I am doing that. What I want to do is subtotal (using Average) on a
premium
| value for a list of insurance policies by the producer. Then, I want a
count
| of those policies that produce the average. In older Excel versions, the
| count and the average would be displayed on different lines. Now, they
are
| all on the same line. I used to be able to color the Count in one color
and
| the Average in another. With them on the same line, I can't do that any
| longer.
|
|