My post is difficult to explain. Below you will see that
values are entered in to the worksheet on 10/22, 10/23 and 10/24. As the
entered values each day impact the calculation of A1..A3, the sum of A1..A3
updates based on the most rercent value entered (14.25 on 10/24). As the
result calculates each day, I'd like to be able to "save" the calculated
value by date and post it to the right of the A1..A3 TOTAL. Is there a way
to reference the value by the date it was calculated?
For example, when the value for 10/24 is entered, I don't want the
calculations for 10/22 and 10/23 to go away. Shift isn't a good explanation.
I want to be able to trend the daily values of the calculation A1..A3.
Thanks for your patience, and for giving this a second look.

I'll illustrate below. I want to be able to "save" a calulated value based
on the date it was entered.

I want to be able to post the results by date and have each result
maintained in the database. Thanks for your insight. I know this should
be possible.


10/22 10/23 10/24 A1 formula result
14.00 14.50 14.25 A2 formula result Results by date
A3 formula result 10/22 10/23 10/24

----------------
TOTAL: (a1..a3) 71.05 69.00 72.34 71.05**


The above TOTAL ** The above is based
on changes each date in the calculated
TOTAL

--
Sony Luvy