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