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

[Christine C]

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.

 

[Frank Kabel]

Hi
could you provide some examples how your data is structured (e.g. post some
example rows of data)

Sounds like SUMIF or SUMPRODUCT
(http://www.xldynamic.com/source/xld.SUMPRODUCT.html)

Also a pivot table might be what you're looking for:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2004/11/26/creating-a-simple-pivot-table/trackback/

 

[Christine C]

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.

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.