Sum Function (was summing 13 cells to the left)

N

Neil S.

Trying to compose a formula that will only sum 13 cells to the left (13 months of data). When columns are added, I still only want to sum thirteens months of data. Can this be done without constanty changing my formulas? Make sense

TIA
Neil S.
 
R

Ron Rosenfeld

Trying to compose a formula that will only sum 13 cells to the left (13 months of data). When columns are added, I still only want to sum thirteens months of data. Can this be done without constanty changing my formulas? Make sense?

TIA,
Neil S.
Click to expand...

Instead of posting a new, virtually identical post, it would be best if you
could tell us what was wrong with the previous solution; and keep it in the
same thread.


--ron
 
S

Steve

I assume you have column labels in row 1 and a formula in
cell A3 that sums B3:N3 - you might have data in columns
beyond N (ie O, P, Q etc). Copy range B3:Q3 (or max
extent of data B3:Z25) to cell C3. Relabel cell B1 and
enter new data in column B. You could create a macro to
do the above.
-----Original Message-----
Trying to compose a formula that will only sum 13 cells
Click to expand...
to the left (13 months of data). When columns are added,
I still only want to sum thirteens months of data. Can
this be done without constanty changing my formulas? Make
sense?
 
Top