Cumulative totals on individual items

[imported_unknown]

I need to keep a running total on 18 individual items. There will be entries against these items weekly. How can I do this. I have tried everything using a current and cumulative column and nothing works.
Thanks
Lctrues
This message was edited by lctrues on 2002-09-29 18:10

 

[PaddyD]

Kind of depends on how your data is set up. In most cases, if you want straightforward summary data then pivot tables will do it...check them out, & post back with more details on what you're trying to do ifyou need...

Paddy

 

[imported_unknown]

This is an example of what I need:
WeekEnding Current Cumulative
9/28/02 100 100
The following week I would replace the week ending date with a current date, replace the current with that weeks production and update the cumulative to reflect all previous and the current for one grand total. I have had some experience with Pivot Tables and will keep looking at them.
Thanks for helping me.
Lctrues
On 2002-09-29 18:09, lctrues wrote:
I need to keep a running total on 18 individual items. There will be entries against these items weekly. How can I do this. I have tried everything using a current and cumulative column and nothing works.
Thanks
Lctrues
This message was edited by lctrues on 2002-09-29 18:10

 

[jmuscat]

If your data was something like below, you could use the sumif function.
Department Purchases
Marketing $1,250
Sales $300
Personnel $850
Personnel $640
Sales $13,500
Sales $285
Sales $6,400
Marketing $3,800
Sales $150
Total Marketing purchases $5,050

Formula for total marketing purchases is =SUMIF(A1:A9,"Marketing",B1:B9)

 

[imported_unknown]

The cumulative totals have to be on individual items as well as an overall cumulative total. Your formular will work great for the overall..It is the individual that is a royal pain.
On 2002-09-29 18:35, jmuscat wrote:
If your data was something like below, you could use the sumif function.
Department Purchases
Marketing $1,250
Sales $300
Personnel $850
Personnel $640
Sales $13,500
Sales $285
Sales $6,400
Marketing $3,800
Sales $150
Total Marketing purchases $5,050

Formula for total marketing purchases is =SUMIF(A1:A9,"Marketing",B1:B9)

 

[imported_unknown]

Department Purchases Cum Purchases
Marketing $1,250 $2,000
An example would be that $800 was entered last week as that weeks marketing purchases. That amount with the $1,250 would be my cumulative. This is an ongoing cycle.
On 2002-09-29 18:35, jmuscat wrote:
If your data was something like below, you could use the sumif function.
Department Purchases
Marketing $1,250
Sales $300
Personnel $850
Personnel $640
Sales $13,500
Sales $285
Sales $6,400
Marketing $3,800
Sales $150
Total Marketing purchases $5,050

Formula for total marketing purchases is =SUMIF(A1:A9,"Marketing",B1:B9)

 

[PaddyD]

please be clearer about how your data is set up - detail the ranges that your data is in, the calculation you want performed etc - give an example & the expected outcome. consider downloading the html maker addin from the link below this post.

Paddy

 

[imported_unknown]

There is an object variable missing once I downloaded the html maker addin. I will try to be clearer on what I need. I am in the process of setting up a spreadsheet that will allow the entry of weekly production of topsoil deliveries by county. I must have a column that will also reflect the cumulative production by county. I will be entering the weekly numbers for a few months. At the end of the production I need to know how much topsoil was delivered into each county.
I hope I have explained this a little better.
Thanks for your time.
On 2002-09-29 19:04, PaddyD wrote:
please be clearer about how your data is set up - detail the ranges that your data is in, the calculation you want performed etc - give an example & the expected outcome. consider downloading the html maker addin from the link below this post.

Paddy

 

[PaddyD]

OK - I'm still not clear on how your data is set up. If you're having problems with the addin, you could post with explicit descriptions e.g. in row 1 I have data headings, in col A I have countries, I want to...Then give an example of your data & the expected outcome.

See also here:
http://www.mrexcel.com/board/viewtopic.php?topic=12429&forum=2

for an example of how to do cumulative & running totals (year to date in this case).

Post back with more info...

Paddy