|In I1:M1 enter your Cost Center letters A - E|
Assuming your first Extended Total is in G2, enter this formula in I2 (adjust as required)
Drag this over to M2 and then drag I2:M2 down as far as you need.
The key is to ensure you use the dollar signs exactly as shown.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.