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