View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cong Nguyen Cong Nguyen is offline
external usenet poster
 
Posts: 20
Default Subtotal formula

Is there a way to set up a formula in column B to sum the COUNT data in
column C as showed below:

Col. A Col. B Col. C
Supplier Subtotal Count
ASI 79 41
38
MT 41 9
14
18
DRS 24 3
3
7
3
4
4
DRS 19 19
GM 17 12
ASI 26 4
9
7
6
MONO 19 14
5

Please help.
Thank you

--
Cong Nguyen