I have a list of numbers that is sumed to a sub total each calender day.

Presently, each day I manually add the new sub total for the day to the
master total for the month. I want the master total to retain the number in
the cell and automatically add the new sub total for each day.

I have created a table with all the days in the year and the following
formula generates the daily subtotal in a cell when the date on the spread
sheet = the day in the table.

=if(and($c$111=$A104,$e$111=D$78)personnel!$e$72,0 )

Where c111 = the day & e111 = the month.

The problem is that each new day all the formula recalculate and I lost the
number from the previous day.

How do I get the formula to only generate once? When the report is opened
for the next day the previous days subtotal is wiped so I can't used the
normal sum function.

or

How do I get the master total to accumulate each new day and ignore the zero
value that is now in the cell where the previous days subtotal was.

HAve spent two days to come up with the above formula and am completely
stumped.

HELP PLEASE!!