Subtotal formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top