Update yearly records
 

Each month I enter a total for the sales amount for the current month and
then I have to add this amount to the total for the year amount.
The following month I save the work book under the new month then I enter
the new monthly sales amount and add this to the total yearly amount.
Is there a simple formula that the current monthly sales amount in Cell A10
can be added to the last month total amount of sales in cell B10?
Thank you.

Update yearly records
 

Hi ED. I have to record monthly income and then accumulate for a
Year-to-Date total. The way I do it is to use column A for the months,
column B for themonthly amount and column C for the Y-T-D total. For
example, in C2 I type "=B2" (no quotes). Then in B3 I type "=B3+C2. If you
copy this down it will give you the cumulative total, month-by-month. HTH
--
Sincerely, Michael Colvin


"ED" wrote:

Each month I enter a total for the sales amount for the current month and
then I have to add this amount to the total for the year amount.
The following month I save the work book under the new month then I enter
the new monthly sales amount and add this to the total yearly amount.
Is there a simple formula that the current monthly sales amount in Cell A10
can be added to the last month total amount of sales in cell B10?
Thank you.