excel simple prob w/running subtotals

  • Thread starter Thread starter diesel cdg
  • Start date Start date
D

diesel cdg

i'm not very well versed in excel and hoping this is a simple problem:

making a cost report and i need to emulate various colums that loo
like this:

ACTUAL THIS WEEK ACTUAL TO DATE
600 81,000
3,500 32,000
100 53,000

SUBTOTAL

4200 166,000

the "TO DATE" column is a running total of values spent, so would
need a separate sheet for every week, or is there a way i can save th
values from the "THIS WEEK" column in a variable or to an externa
file?

any advice is much appreciated - thanks
 
sorry, messed up the formatting....

the columns are:

ACTUAL THIS WEEK
600
3,500
100

ACTUAL TO DATE
81,000
32,000
53,000

and then the SUBTOTALS of each column.. sorry if this confuse
 

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

Back
Top