how do I add cells totals

J

Joe

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!!!!
 
R

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!
==============================================

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!!!!
 
Top