View Single Post
  #2   Report Post  
RagDyeR
 
Posts: n/a
Default

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