cumulative totals #2

I have a worksheet like this:
/ A / B / C /
/ 1 / water per day / cumulative water / beginning water /
2 / 21 / 71 / 50 /

I want a running sum in column B. In other words, I want cumulativ
water to start out at 0 (B2). when I enter 21 in cell A2, I want it t
add water per day to the beginnig water (C2)(21+50=71) and display tha
number in column B. Then the next day I enter a number in A2, say 15, 
want B2 to come out to 86 (71 from the previous day plus the 15 fo
today). I will be entering a "water per day" everyday and want th
running sum displayed in B2.
Thanks for your help!!

--
dcaput
-----------------------------------------------------------------------
dcaputo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1492
View this thread: http://www.excelforum.com/showthread.php?threadid=26560

0
10/1/2004 7:15:57 PM
excel.misc 78881 articles. 5 followers. Follow

6 Replies
491 Views

Similar Articles

[PageSpeed] 50

Seed cell b2 with the first value. Then, in A2 this will do it auotmatically
right click sheet tab>view code>copy/paste this

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$2" Then Exit Sub
x = Cells(Rows.Count, "b").End(xlUp).Row
Cells(x + 1, "b").Value = Target + Cells(x, "b")
End Sub

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"dcaputo" <dcaputo.1dgpfb@excelforum-nospam.com> wrote in message
news:dcaputo.1dgpfb@excelforum-nospam.com...
>
> I have a worksheet like this:
> / A / B / C /
> / 1 / water per day / cumulative water / beginning water /
> 2 / 21 / 71 / 50 /
>
> I want a running sum in column B. In other words, I want cumulative
> water to start out at 0 (B2). when I enter 21 in cell A2, I want it to
> add water per day to the beginnig water (C2)(21+50=71) and display that
> number in column B. Then the next day I enter a number in A2, say 15, I
> want B2 to come out to 86 (71 from the previous day plus the 15 for
> today). I will be entering a "water per day" everyday and want the
> running sum displayed in B2.
> Thanks for your help!!!
>
>
> -- 
> dcaputo
> ------------------------------------------------------------------------
> dcaputo's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=14924
> View this thread: http://www.excelforum.com/showthread.php?threadid=265603
>


0
Don
10/1/2004 7:55:52 PM
=IF(N(A2),C2+SUM(A2:INDEX(A:A,MATCH(9.99999999999999E+307,A:A))),0)

Hope this helps

--
Domeni
-----------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1078
View this thread: http://www.excelforum.com/showthread.php?threadid=26560

0
10/1/2004 7:58:27 PM
Domenic,

I think your formula may be adaptible to my problem but I cannot figure out 
exactly how it works and what it does.  Can you help me?

My problem is:

I have Sales$ by Agent and CatNo (many Agents and many CatNos).

I want to sort the data by Agent/Sales$ (desc) and calculate the the 
Cumulative Sales$ for each Agent from largest sales CatNo to smallest and 
repeat the calcaulation for all Agents.

I can copy the formula  = sum(c$2:c2) from the first CatNo to the last to 
accomplish this for a single Agent but would have to restart the formula at 
the start of each new Agent and copy it down for his CatNos each time - far 
too tedious for a couple of hundred Agents.

Will your formula solve my problem?

Thanks,  Raymond

"Domenic" wrote:

> 
> =IF(N(A2),C2+SUM(A2:INDEX(A:A,MATCH(9.99999999999999E+307,A:A))),0)
> 
> Hope this helps!
> 
> 
> -- 
> Domenic
> ------------------------------------------------------------------------
> Domenic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10785
> View this thread: http://www.excelforum.com/showthread.php?threadid=265603
> 
> 
0
Raymond1 (40)
11/10/2004 5:03:02 PM
Domenic,

I think your formula (below) may help me solve a nagging problem but I 
cannot figure out how it works or how to use it.  Can you help?

My problem is:

I have Sale$ by Agent  by CatNo (many Agents and many CatNos).  The data are 
sorted by Agent/Sales$ (desc).

I want to calc the cumulative Sales$ for each Agent starting at the Agent's 
first CatNo through his last CatNo.

Of course, I can do this one Agent at a time by entering  =sum(c$2:c2) at 
the first record for the first Agent and copying it down for his CatNos.  To 
calc the second Agent, the formula would have to be restarted at the address 
of his first CatNo and be copied down for his data and so on.  Far too 
tedious for several hundred Agents.

Will your indexing formula help or do you have a suggestion that will?

Thanks,  Raymond


"Domenic" wrote:

> 
> =IF(N(A2),C2+SUM(A2:INDEX(A:A,MATCH(9.99999999999999E+307,A:A))),0)
> 
> Hope this helps!
> 
> 
> -- 
> Domenic
> ------------------------------------------------------------------------
> Domenic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10785
> View this thread: http://www.excelforum.com/showthread.php?threadid=265603
> 
> 
0
Raymond1 (40)
11/10/2004 5:18:03 PM
Domenic,

I think your formula (below) may help me solve a nagging problem but I 
cannot figure out how it works or how to use it.  Can you help?

My problem is:

I have Sale$ by Agent  by CatNo (many Agents and many CatNos).  The data are 
sorted by Agent/Sales$ (desc).

I want to calc the cumulative Sales$ for each Agent starting at the Agent's 
first CatNo through his last CatNo.

Of course, I can do this one Agent at a time by entering  =sum(c$2:c2) at 
the first record for the first Agent and copying it down for his CatNos.  To 
calc the second Agent, the formula would have to be restarted at the address 
of his first CatNo and be copied down for his data and so on.  Far too 
tedious for several hundred Agents.

Will your indexing formula help or do you have a suggestion that will?

Thanks,  Raymond


"Domenic" wrote:

> 
> =IF(N(A2),C2+SUM(A2:INDEX(A:A,MATCH(9.99999999999999E+307,A:A))),0)
> 
> Hope this helps!
> 
> 
> -- 
> Domenic
> ------------------------------------------------------------------------
> Domenic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10785
> View this thread: http://www.excelforum.com/showthread.php?threadid=265603
> 
> 
0
Raymond1 (40)
11/10/2004 5:19:01 PM
Assuming that Column A contains the Agent Name, Column C contains th
Sales Amount, and your data starts on the second row...

C2, copied down:

=SUMIF($A$2:A2,A2,$C$2:C2)

Hope this helps!

Raymond Wrote:
> Domenic,
> 
> I think your formula (below) may help me solve a nagging problem but I
> cannot figure out how it works or how to use it.  Can you help?
> 
> My problem is:
> 
> I have Sale$ by Agent  by CatNo (many Agents and many CatNos).  Th
> data are
> sorted by Agent/Sales$ (desc).
> 
> I want to calc the cumulative Sales$ for each Agent starting at th
> Agent's
> first CatNo through his last CatNo.
> 
> Of course, I can do this one Agent at a time by entering  =sum(c$2:c2
> at
> the first record for the first Agent and copying it down for hi
> CatNos.  To
> calc the second Agent, the formula would have to be restarted at th
> address
> of his first CatNo and be copied down for his data and so on.  Far too
> tedious for several hundred Agents.
> 
> Will your indexing formula help or do you have a suggestion that will?
> 
> Thanks,  Raymond
> 
> 
> "Domenic" wrote:
> 
> >
> > =IF(N(A2),C2+SUM(A2:INDEX(A:A,MATCH(9.99999999999999E+307,A:A))),0)
> >
> > Hope this helps!
> >
> >
> > --
> > Domenic
> 
> ------------------------------------------------------------------------
> > Domenic's Profile
> http://www.excelforum.com/member.php?action=getinfo&userid=10785
> > View this thread
> http://www.excelforum.com/showthread.php?threadid=265603
> >
> 

--
Domeni
-----------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1078
View this thread: http://www.excelforum.com/showthread.php?threadid=26560

0
11/10/2004 7:19:54 PM
Reply:

Similar Artilces:

Display Totals of Calculated Field
Hello, I've inserted some calculated fields that are working fine. (I'm using Excel 2007) I am grouping by year, and the 'regular' fields show the subtotals by year, but my calculated fields do not show subtotals at all. Any suggestions would be appreciated! I removed some subtotals and the calculated field totals magically appeared. Not sure why, but it's working. Sorry about that. "Joyce" wrote: > Hello, > > I've inserted some calculated fields that are working fine. (I'm using Excel > 2007) > > I am g...

having total of formula automatically change
HI - hoping to get some assistance here - We have a spreadsheet that has the following: Column 1 - Cost (Dealer Cost) Coumn 2 - Mark up (using : =SUM(C7*0.05) ) Column 3 - Selling cost (=SUM(C7:D7) ) What we need to have happen at this point is Colum 4 - Automatically rounds the amount to *.95 cost and then hav it refigure the %of markup in Column 2 SO: IF we have : $42.95 $2.15 45.10 Need this to reformulate 45.10 to 44.95 an then refigure $2.15 mark up cost to the correct % -- Message posted from http://www.ExcelForum.com If I understand you correctly: rounded ...

Workflow problem #2
Hi, Ive setup a rule in the workflow manager to email a template on creation of a new lead in CRM v3.0 SBE. When a lead is created , We get a "Not enough privilege to access the Microsoft CRM object or perform the requested operation" logged in the debug log and the job ends up in the workflow monitor as paused. (The workflow service is running as NT AUTHORITY\NETWORK SERVICE). However, if the rule is manually run as apply rule from the GUI, the template works ok. Any suggestions where to look first to solve the workflow issue? Its OK. Ive solved the issue which was running...

cumulative total
Is it possible to have a cell that will keep a cumulative total from a single cell entry. For example cell 1 is where the entry is made and cell 2 is the cumulative total. enter 2 in cell 1 will change cell 2 to 2 then key in 5 in cell 1 and cell 2 then adds 5 to become 7. Thanks in advance. Dennis -- dfisherkern ------------------------------------------------------------------------ dfisherkern's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31661 View this thread: http://www.excelforum.com/showthread.php?threadid=513495 See this: http://mcgimpsey.com/e...

Crystal reports 9.2.2 upgrade
Hello I have crystal report advanced 9.2.0 and i really need an update for version 9.2.2 Can anybody tell me how can i get this download? It was a ftp: "ftp://ftp.crystaldecisions.com/outgoing/TS/CC/CRPro922.zip " but it missing. THANK YOU !! razvan rbacria@hotmail.com you need to contact businessobjects.com once they have verified your crystal 9.2.0 license they will send out or give you permission to download crystal 9.2.2 -- John O'Donnell Microsoft CRM MVP http://www.mscrmfaq.us "razvanb" <razvanb@discussions.microsoft.com> wrote in message news...

Incorrect totals in Pivot Table
I have created a calculated field in my pivot table. It works properly. However, the column and row totals do not give intended results (sum of displayed results). Rather they use the same formula on all data in that part of the table. Here are the details: Data Table shows payments by transaction for all customers (field name=AMT). Customer may have + and - payments on any day. I need to show net payments per day by customer. I then need to calculate 31% of net payment BUT only if net >0. Pivot table: created 2-way table, calculating sum of pmts by customer by day. works fine ca...

Lose the 0 in the Total cell
I’m using the formula below, in a worksheet to count cells containing the letter S. My problem is in the total cell, it displays a 0 until I enter an S in the cells it is totaling. Is there a way I can modify the formula so that it does not display the 0? I’m using Excel 2007, but the formula must work in Excel 2003. =COUNTIF(B5:B22,"s")+COUNTIF(H5:H21,"s") Thanks, Malcolm =IF(COUNTIF(B5:B22,"s")+COUNTIF(H5:H21,"s")=0,"",COUNTIF(B5:B22,"s")+COUNTIF(H5:H21,"s")) -- Gary''s Student - gsnu201003 ...

Not allowing duplicates to be entered in a column #2
I am trying to ensure that users entering data into an Excel workshee only enter unique values in a particular column (values provide earlier in the column cannot be duplicated). Does anyone know a effective way to approach this requirement -- Message posted from http://www.ExcelForum.com One way: http://cpearson.com/excel/nodupentry.htm In article <blstamps.156odv@excelforum-nospam.com>, blstamps <<blstamps.156odv@excelforum-nospam.com>> wrote: > I am trying to ensure that users entering data into an Excel worksheet > only enter unique values in a particu...

Gift Cards #2
I'm opening a new retail camera and photo-finishing store. RMS seems to offer pretty much the "best" POS option for me (being a small store I can't afford $25k for a "bottom of the barrel" retail solution..cough cough). The one thing that really seems to be missing is the ability to do gift cards. I want to do gift cards, but I *really* want to have the gift card database stored locally (so there are ZERO per-transaction charges). I know that Mercury has a "no cost" gift card - but there HAS to be a catch....and usually that catch with gift cards...

Archiving problem #2
I have set up the 'Archive all messages sent or received by mailboxes on this store' setting in Exchange 2003 to forward to the 'administrator' user. This works fine, except that if an e-mail is sent directly to 'administrator@<domain>.com' it gets bounced back with the following message:- This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed. administrator@<domain>.com I have tested this on several different Exchange servers and the problem happens on all of them. I assume then that this ...

charting totals
I have the following data and would like to chart total number by dept. that took at least one training class, at least two etc. not sure how to chart with data like this????? ACADEMIA At Least 3," 1 ACADEMIA At Least 3," 1 ACADEMIA At Least 3," 1 ACADEMIA Total At Least 3," 2 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA Total At Least One 5 CBD MANAGERS At Least 2 1 CBD MANAGERS Total At Least 2 1 CBD MANAGERS At Least 3," 1 CBD MANAGERS At Least 3," 1 CBD MANAGERS At...

version changes #2
i created a business card on Publisher (xp) but when i try to load it onto a computer w/ a color printer that has publisher ('97) it says i can't load stuff from another version. is there any way i can "downgrade" the project to make it compatible with the older version? ...

HRESULT #2
is HRESULT only used in COM interface programming? I see this quite often in a COM module call. I've seen it mostly used with COM and Windows message calls, but I think HRESULT is just a long that is encode with attributes so you could likely use it wherever. Here are some interesting articles: http://en.wikipedia.org/wiki/HRESULT http://msdn2.microsoft.com/en-us/library/dcy94zz2(VS.80).aspx#vcconattributeprogrammmingfaqanchor1 Tom "June Lee" <iiuu66@yahoo.com> wrote in message news:4gulu3prunl23jd6fvvihal7ps73kef8j6@4ax.com... > is HRESULT only used in COM inte...

Cumulative Error
Ill try and explain this as best I can. I have a form with a subform, the subform contains all the data, the main form is used as a connection link. On the subform I want to create a cumulative total specific to the project and department according to month so essentially I want something like: (Main Form: Frm_Edit Department Detailed) Project: A Department: 0004 (Main Form: Frm_Edit Department Sub) Month Planned Cumulative June 342 342 Jul 123 465 Aug 456 921 At the moment I have the following as the control sourc...

attachment question #2
Hi every1... just had a question about attachments in outlook 2000 when i attach a file is it possible to have this msg appear in each email that has a attachment? the msg is (See attached file: filename.ext) my friend using lotus notes has it generated automatically.. just wondering if outlook had this option. Thanks for your help ------------------------------------------------ ~~ Message posted from http://www.OutlookForum.com/ ~~ View and post usenet messages directly from http://www.OutlookForum.com/ any 1? ;) ------------------------------------------------ ~~ Message posted fro...

Size limit on total items
I know we can set a mailbox size limit, is there a default to the number of items one can have in a mailbox, i.e ost file, etc. Booker On Mon, 28 Nov 2005 13:16:08 -0800, "BookerW" <BookerW@discussions.microsoft.com> wrote: >I know we can set a mailbox size limit, is there a default to the number of >items one can have in a mailbox, i.e ost file, etc. >Booker > What is the goal? One of my users gets a Handle is invalid error when trying to open up their mailbox. The only wierd thing about the users mailbox is it has about 115,000 items in it. The siz...

merging data from 2 spreadsheets
Hello I work in a school and often export or collect data into spreadsheets of student grades and assessments etc. I often have to combine different lots of assessments from 1 or 2 spreadsheets into one and do this by arranging windows or 'comparing side by side' and go down the list of students in both files, (sorted by name) then when the students are in the exact order of rows, I copy the columns of data i want from one file into the other. This is very tedious and making me go blind! Is there a better way of doing this?? Like a query or something. Anything? I'm using Off...

Lookup tables #2
want to use lookup tables as poor man's db. have about 200 uniquely numbered stores, each time a call comes in we log it by that number, and each "record" has 11 "fields" or columns. if the list is sorted in ascending order, how can i use a a vlookup in combo with macro to go in and key off the unique number and bring all the rows of data back identified with that unique number to one page? Stores may have only one "record" and some may 15. formula would look at the keyed in number...say 101 and go to lu table and start with 101 and repeat until it reach...

Error message on startup #2
I've started using my copy of Outlook 2007 that came along with Office 2007 Pro. Got it all coordinated with my email server but every time it (Outlook) opens I see the following message: http://tinypic.com/r/b5fg3o/3 Any ideas? Thank You All, -plh -- Where are we going and why am I in this HAND BASKET?? The error says it all; the issue is with an Avast add-in that you installed. You'll be better off reinstalling Avast without the email integration tools as it doesn't add an extra level of protection anyway. See http://www.msoutlook.info/question/20 -- Robert Sparnaaij [MVP-...

How do I do a cumulative frequency graph?
I have a large amount of data (60k lines) and want to display a cumulative frequency of the data. Example... chart starts @ 0,0 and end at $1.00 (x) and 100% (y). It will visually show at any given x value (between 0 and 1.00) the cumulative % of the time that value (and below) comes up. (.50 and below is 40% of the data). I have played with histograms, but that just shows the frequency of 1 x value. I need this to be cumulative for that x value and all values lower than it. Any ideas? Ted, I think you can use the COUNTIF function: =COUNTIF(x,"<=x") where x is the x val...

CLIPBOARD #2
In EXCEL, there is a small window that pops up that shows the cell references and the copy of the clipboard. How can I activate that window??? Larry which version of Excel are you using? >-----Original Message----- >In EXCEL, there is a small window that pops up that shows >the cell references and the copy of the clipboard. > >How can I activate that window??? > >Larry >. > ...

Group Totals 11-14-07
Vendors -- Product Invoice - # Inv Date - Quantity Product Total Product Invoice - # Inv Date - Quantity Product Total Sum=([Quantity]) This works. Now I want the Grand Total for each product on the final page. I can get a grand total for all products but I want a grand total for each product. Thanks for your help. Taylor Create a totals query similar to your report's record source that provides grand totals for each product. Use this totals query as ...

Customising Outlook Today #2
I have changed from MS 2000 to MS XP recently and am still using Outlook 2000. I am not able to customise my Outlook Today, can anyone suggest anything. Follow the instructions given in the following KB article; http://support.microsoft.com/?id=820575 -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -Backup and Restore -Create an Office XP CD slipstreamed with Service Pack 3 ----- "Katherine" <kshepherd@bachellp.com> wrote in message news:2d8c301c46a61$f285e650$a501280a@phx.gbl... >I have changed from MS 2000 to MS XP recently and am > s...

Excel Upgrade #2
I upgraded my users (all of the are Power Users) to Office 2003 from Office 2000 and now I get an error message "The workbook has lost its VBA project, ActiveX controls and any other programmability-related features". They have the full install running from thier computers. I don't have the problem as an administrator but they ALL have the problem as Power Users. None of the articles on the knowledge base helped nor the help in the software. The problem is really obivious in Excel. Its definitely a rights thing but I don't know which Hive key. Anyone else seen this?? Search ...

histogram #2
I am trying to create a histogram and when I provide a data range it tells me that data must be a contiguous reference and won't create the histogram. does anyone know how to fix this? thanks. canadian excel user - >I am trying to create a histogram and when I provide a data range it tells >me that data must be a contiguous reference and won't create the histogram. >does anyone know how to fix this? thanks. < Enter your data in a single column in adjacent cells. For a slightly better histogram, try the free add-in from the Better Histogram page at www.treeplan.co...