Formulas - Add to two columns without subtracting but from one
 

I am setting up a new worksheet as follows:

Current Admitted Discharged Total From Region
Population

I have set a formula to add # admitted for the month subtracted by the
number discharged for the month to get my current population. Now this is
where my question comes in. I want to add the total number admitted for the
month to the Total from Region ( this number needs to only go up) which is no
problem, except that need to change the Admitted monthly which could go up or
down without taking the number down in Total from Region. Any suggestions
for a formula that will work

Formulas - Add to two columns without subtracting but from one
 

Hi,
let's say that information starts in row 2 , the first total will be the
same as the Admited number so formula in D2 will be
=B2

then in D3 the formula will be

=D2+B3

copy this last formula down

if this helps please click yes., thanks

"SBates" wrote:

I am setting up a new worksheet as follows:

Current Admitted Discharged Total From Region
Population

I have set a formula to add # admitted for the month subtracted by the
number discharged for the month to get my current population. Now this is
where my question comes in. I want to add the total number admitted for the
month to the Total from Region ( this number needs to only go up) which is no
problem, except that need to change the Admitted monthly which could go up or
down without taking the number down in Total from Region. Any suggestions
for a formula that will work