Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have completed a very complex Excel spreadsheet with a lot of equations, except ...

I forgot to include September

I have Jan through Dec, all the months, except the calculations for September. Of course all

the equations are currently perfect for the data that's here.

How do I add a whole new column without ruining the previous equations?

PS: tomorrow is my holidays and I have to go to work to finish this table, so bad.

would really appreciate some kind expertise :)

share|improve this question

1 Answer 1

Assuming the following:

The equations are using the format (A1:D1) and not (A1,B1,C1,D1). You want the new data to be FACTORED INTO the equation.

The following will work: Right-click on the column letter above the October column. Click Insert. Type all your data in. Your equation column should reflect your new data.

Please tell me if my above assumptions were incorrect.

share|improve this answer
    
thank you very much dave im going to work in 4 hours its 2am im in valencia spain but once im at work ill try it. –  Craig Gunn Dec 14 '12 at 0:46
    
no prob craig! tell me whether it works or not! –  golddove Dec 14 '12 at 4:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.