Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - SUM
Hi,
I'm wondering if there is a variation on the SUM formula to pick up data in rows/columns added outside the existing range? Thanks in advance to anyone who can help. -- Carla |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - SUM
No.
Regards, Fred "Carla" wrote in message ... Hi, I'm wondering if there is a variation on the SUM formula to pick up data in rows/columns added outside the existing range? Thanks in advance to anyone who can help. -- Carla |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - SUM
Should not..Can you please elaborate your query..
-- Jacob "Carla" wrote: Hi, I'm wondering if there is a variation on the SUM formula to pick up data in rows/columns added outside the existing range? Thanks in advance to anyone who can help. -- Carla |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - SUM
Hi Jacob,
I'm referring to a formula summing data above it in several rows, or beside it in several columns. If you add a row/column in the middle of the series, the additional data gets included in the sum. I would like to find a way to have the SUM formula pick up any data that I enter outside the existing data range (in case I forget to update the formula to include the new data). Or are there other checks and balances that you can recommend? Thanks -- Carla "Jacob Skaria" wrote: Should not..Can you please elaborate your query.. -- Jacob "Carla" wrote: Hi, I'm wondering if there is a variation on the SUM formula to pick up data in rows/columns added outside the existing range? Thanks in advance to anyone who can help. -- Carla |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - SUM
Carla try the below.....
Sum of all cells to the left =SUM(OFFSET($A$1,ROW()-1,0,1,COLUMN()-1)) Sum of all cells to the top =SUM(OFFSET($A$1,0,COLUMN()-1,ROW()-1,1)) -- Jacob "Carla" wrote: Hi Jacob, I'm referring to a formula summing data above it in several rows, or beside it in several columns. If you add a row/column in the middle of the series, the additional data gets included in the sum. I would like to find a way to have the SUM formula pick up any data that I enter outside the existing data range (in case I forget to update the formula to include the new data). Or are there other checks and balances that you can recommend? Thanks -- Carla "Jacob Skaria" wrote: Should not..Can you please elaborate your query.. -- Jacob "Carla" wrote: Hi, I'm wondering if there is a variation on the SUM formula to pick up data in rows/columns added outside the existing range? Thanks in advance to anyone who can help. -- Carla |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) |