View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ED
 
Posts: n/a
Default 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.