Formulas - Add to two columns without subtracting but from one

S

SBates

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>
 
E

Eduardo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top