Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a cell or column to be included in a sum formula
Cell A1 is my "Total" column, with the formula of =sum(B1:X1). When I try to
add a new cell/column to the left of B1 (which then becomes B1, and B1 becomes C1, etc.), the formula does not include the new B1, but instead changes to =sum(C1:X1). I have tried using =sum($B1:X1) but that didn't work. I'd appreciate any insight as to how I can add a new cell/column to the left of the existing first cell/column (i.e., B1) and have the formula adjust to include the new cell/column. I hope that makes sense. Thank you in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find what number in Column A is not included in Column B? | Excel Discussion (Misc queries) | |||
Unable to sort when column is included in range | Excel Discussion (Misc queries) | |||
Help, add subtotals included in one column to get a grand total | Excel Discussion (Misc queries) | |||
Can a cell in excel contain text and have a formula included? | Excel Discussion (Misc queries) | |||
prevent column from being included in sort in Excel | Excel Discussion (Misc queries) |