View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default subtotal/pivot table question

You can put the data field in twice in the data area. Make one a sum and
one a count.

--
Regards,
Tom Ogilvy

"Gary Keramidas" wrote in message
...
not sure exactly which one i'll use, but is there a way to have a count on
the same line as the subtotal for the group break?

--


Gary