| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I sum inserted cells in EXCEL?
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 |
|
#2
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
| Excel cannot shift nonblank cells | Excel Discussion (Misc queries) | |||
| How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
| partial photos in Excel cells | Setting up and Configuration of Excel | |||
| Excel Charts and cells | Charts and Charting in Excel | |||
Linear Mode
