Subtotal formula

[Cong Nguyen]

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

 

[bj]

This is for display only,
except for the 17 vs 12 next to the GM
in cell B2
=if(A3<>"",C2,C2+B3)
select b2 format-conditon format
equation is =len(A2)=0 format font color as white
copy B2 and paste down as far as you need it.

 

[Cong Nguyen]

Thank you for the quick response, and sorry about the mistake.
It should be:

GM 17 17