ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I add cells totals (https://www.excelbanter.com/excel-discussion-misc-queries/31391-how-do-i-add-cells-totals.html)

Joe

how do I add cells totals
 
what i need to do is a monlthly sales forcast, example:
Unit Cost X how many sold = total + (jan/05 (previous) month's total =
(current month Feb/05) total

30 X 65 = total (1950) + 930 = total

I need to do this from Jan thur Dec on each line/service.

Please Help!!!!

RagDyeR

Do all the numbers exist in the current sheet?

A = unit cost
B = total amt. sold
C = previous sales
D = this formula:
=A1*B1+C1
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Joe" wrote in message
...
what i need to do is a monlthly sales forcast, example:
Unit Cost X how many sold = total + (jan/05 (previous) month's total =
(current month Feb/05) total

30 X 65 = total (1950) + 930 = total

I need to do this from Jan thur Dec on each line/service.

Please Help!!!!




All times are GMT +1. The time now is 09:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com