G
Guest
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.
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.