how do I sum inserted cells in EXCEL?

  • Thread starter YingRui Oliviero
  • Start date
Y

YingRui Oliviero

I am having problem to sum the cells of inserted colums. Initial total colum
is in colum B, cell is B10. Every month, there will be 3 colums inserted by
running a macro in another worksheet. The initial colum B will become colum
E. I need total colum to be updated as new colums inserted. after 3 months I
want to see in cell K10 is the result of SUM(D10,G10,J10).

Many thanks.

YingRui Oliviero
 
B

Bernie Deitrick

YingRui,

Assuming that the only value in row 10 is a sum formula, insert a blank
column B, to move your formula into C10, and use the formula

=SUM(A10:B10)

Then make sure that your macro inserts columns between existing columns and
the blank column.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

the If Statements 2
How do I sum column D and F based on multiple column criteria? 12
Conditional sum equals 0 4
Adding multiple numbers in one cell 16
How do I sum cells by refering to discrete values? 7
Help with looping in Excel 5
How do I change the tab order in an Excel worksheet? 3
IF function question 1

Top