View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tina
 
Posts: n/a
Default how to sum and count in subtotal

How do i apply or use from sub-total one column as sum and another colum as
count using the same data: Example:
Amount
Store 1 $500
Store 2 300.00
subtotal $800 Using sum is $800
but using Count should be 2