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