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

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" wrote:

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

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

GM 17 17


--
Cong Nguyen



"Cong Nguyen" wrote:

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