I need a function to update sales/expenses based on previous tota.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a function to help me calculate my monthly sales. Half of spreadsheet
data is previous months sales/expenses. I want to calculate the one month's
totals based on the previous months totals. In effect what I will be doing
is changing sales totals each month. For example, if October sales were
15,000 (ten months ended Oct) nd I change ten months ended November sales to
20,000, actual November sales would be 5,000.

If there is an easy solution, I would appreciate any input. Thanks.
 
 
Christine C said:
I need a function to help me calculate my monthly sales. Half of spreadsheet
data is previous months sales/expenses. I want to calculate the one month's
totals based on the previous months totals. In effect what I will be doing
is changing sales totals each month. For example, if October sales were
15,000 (ten months ended Oct) nd I change ten months ended November sales to
20,000, actual November sales would be 5,000.

If there is an easy solution, I would appreciate any input. Thanks.
Click to expand...



For example:

10 months ended Oct. 31 Month of Oct.

Kitchen.....517,546 44,069
Office 128,282 9,811


I want the change of figures in the first column to calculate the figures in
the second column automatically...having excel do the work for me. If there
is any function, this would be great. Thanks.
 
Back
Top