how do I add cells totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!
 
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!!!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countifs or a pivot 1
How to dynamically add up varying # of cells base on a value 12
Using Cell Names 1
Auto extract data & inserts rows additional rows automatically 3
sumproduct value error 4
Calculating total amount in a Pivot Table 1
Percentage when total sales is a credit 2
Running total by date 2

Back
Top