Help! I need to create a running total that can will reset itself.

**hackshow51** · 03-20-2015, 05:54 PM

I have a set of 2000 random numbers in on, all between 0 and 1. I have also set up a second column where these random numbers are assigned a pass or fail value, 0 or 1 (0-0.75 = 0, 0.75-1 = 1) When these numbers are randomly generated i need a running sum until the value changes.

Example

Pass/fail......running sum
0.............. 1
0...............2
0.............. 3
0...............4
1...............1
1...............2
0...............1
0...............2
1 ..............1
0...............1
0...............2
0...............3

I understand the logistics behind what needs to be done, I just am having trouble finding the proper function in excel!

**FDibbins** · 03-20-2015, 06:06 PM

Try this...

	A	B
2	0	1
3	0	2
4	0	3
5	0	4
6	1	1
7	1	2
8	0	1
9	0	2
10	1	1
11	0	1
12	0	2
13	0	3

B2=IF(A2=A1,B1+1,1)
copied down

**newbie4** · 03-20-2015, 06:28 PM

Not fully understanding the question. You want a running some of all 0s and another running sum of all 1s based on the value 1,2,3,4 etc.?

Assuming your table is set up the way you posted it, the formula is

sum of 0s
=SUMIF(A1:A12,0,B1:B12)

sum of 1s
=SUMIF(A1:A12,1,B1:B12)

Thanks,
Newb

**FDibbins** · 03-20-2015, 06:33 PM

Newbie, you could be right there. I took it that the OP wanted the count to reset every time the value in A changed.

Guess we will have to wait and see

Thats the good thing about forums, different people read the exact same thing, different ways

**hackshow51** · 03-20-2015, 10:06 PM

Thanks for the help guys, however I'm still having some issues. I do want the count to reset every time the Value in A changes, it should reset to 1, not 0. Any recommendations for a next step?

**soberguy** · 03-20-2015, 10:08 PM

Then FDibbins should have nailed it. You just have to manually enter B1.

**hackshow51** · 03-20-2015, 10:18 PM

Yes, now it is fixed, thanks for all the help!

**FDibbins** · 03-20-2015, 10:27 PM

Happy to help, thanks fo rthe feedback

**hackshow51** · 03-20-2015, 10:51 PM

One further question, if I then want to sum the end points of each reset, and calculate an average of these values, how would i do this?

Example

0.....1
0.....2
0.....3
1.....1
1.....2
0.....1
0.....2
1.....1
1.....2
1.....3
0.....1

In this case i would need the function to sum (3+2+2+3+1) in order to get an average of the end points

***I really appreciate the help, this is supposed to be an introductory course but my professor is rather lacking in his explanations, and i don't find these to be the most straightforward questions***

Help! I need to create a running total that can will reset itself.

LinkBack

Thread Tools

Rate This Thread

Display

Help! I need to create a running total that can will reset itself.

Re: Help! I need to create a running total that can will reset itself.

Re: Help! I need to create a running total that can will reset itself.

Re: Help! I need to create a running total that can will reset itself.

Re: Help! I need to create a running total that can will reset itself.

Re: Help! I need to create a running total that can will reset itself.

Re: Help! I need to create a running total that can will reset itself.

Re: Help! I need to create a running total that can will reset itself.

Re: Help! I need to create a running total that can will reset itself.

Thread Information

Users Browsing this Thread

Similar Threads

Need a formula for running total to reset at zero

Excel 2007 : calculate a running total, with a conditional reset?

Running total reset by zero

How do i create a running total in Excel?

IF/THEN Statements to Create a Running Total

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions