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.

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.