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

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.

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/2...ble/trackback/

--
Regards
Frank Kabel
Frankfurt, Germany
"Christine C" <Christine schrieb im Newsbeitrag
...
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" wrote:

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.