Formulas - SUM

  • Thread starter Thread starter Carla
  • Start date Start date
C

Carla

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.
 
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 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))
 
Back
Top