Thread
:
how do I sum inserted cells in EXCEL?
View Single Post
#
2
Bernie Deitrick
Posts: n/a
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
"YingRui Oliviero" <YingRui
wrote in
message ...
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
Reply With Quote