View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anthony Anthony is offline
external usenet poster
 
Posts: 275
Default Subtotal Function

I would like to subtotal two ways. I have three colums, see examples.

Req. Item Qty Dept
2XL Gowns 10 L&D
2XL Gowns 11 UPC2
2XL Gowns 15 L&D

I want it to sum the about for each dept and then count that L&D had 25 and
they ordered twice and then 11 for UPC2 and got it once, can I do that using
subtotal.

Thanks