#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Running Totals

Hi,

I'm working through a college project using Excel. One of the examples is
to generate a random event (toss of a coin) and then record the number of
outcomes ie how many times heads comes up & how many times tails comes up.

I can't see a way to record the running totals - there's a similar example
given in the notes but i think it might have been done in Lotus 1-2-3

IF(B2="Yes",b3=b3+1, b4=b4+1)

I've tried various permutations of IF, COUNTIF.

Thanks for looking - any suggestions gratefully received.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,696
Default Running Totals

so, do you have a list of Yes and No's? If so, depending on direction..

If going from B2 - IV2, then...

B3 = countif(2:2,"Yes")
B4 = countif(2:2,"No")

would do that...

If you want a running total, then on:

B3, =if(B2="Yes",1,0)
B4 =if(B2="No",1,0)

then, in each subsequent column..

C3, =if(C2="Yes",B3+1,B3)
C4, =if(C2="Yes",B4+1,B4)

"Pickup" wrote:

Hi,

I'm working through a college project using Excel. One of the examples is
to generate a random event (toss of a coin) and then record the number of
outcomes ie how many times heads comes up & how many times tails comes up.

I can't see a way to record the running totals - there's a similar example
given in the notes but i think it might have been done in Lotus 1-2-3

IF(B2="Yes",b3=b3+1, b4=b4+1)

I've tried various permutations of IF, COUNTIF.

Thanks for looking - any suggestions gratefully received.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,696
Default Running Totals

Oops, on that last formula should be

C4, =if(C2="No",B4+1,B4)

"Sean Timmons" wrote:

so, do you have a list of Yes and No's? If so, depending on direction..

If going from B2 - IV2, then...

B3 = countif(2:2,"Yes")
B4 = countif(2:2,"No")

would do that...

If you want a running total, then on:

B3, =if(B2="Yes",1,0)
B4 =if(B2="No",1,0)

then, in each subsequent column..

C3, =if(C2="Yes",B3+1,B3)
C4, =if(C2="Yes",B4+1,B4)

"Pickup" wrote:

Hi,

I'm working through a college project using Excel. One of the examples is
to generate a random event (toss of a coin) and then record the number of
outcomes ie how many times heads comes up & how many times tails comes up.

I can't see a way to record the running totals - there's a similar example
given in the notes but i think it might have been done in Lotus 1-2-3

IF(B2="Yes",b3=b3+1, b4=b4+1)

I've tried various permutations of IF, COUNTIF.

Thanks for looking - any suggestions gratefully received.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Running Totals

Sean, Many thanks for the reply.

Sorry my omission - the question specifies that the results of each throw
should appear in a single cell (the throws are simulated by switching auto
calc off and then using F9 to generate a new number) with running totals
being kept for the count of heads & tails.

I think you mean B2 in your examples rather than C2 .. IF(C2="Yes"... ??

I tried something like this already unfortunately when the answer's no C3
would reset to 0. I also tried

C3, =IF(B2="Yes",B3=B3+1,B3=B3)
C4, =IF(B2="No",B4=B4+1,B4=B4)

and

C3, =IF(B2="Yes",B3+1,B3)
C4, =IF(B2="No",B4+1,B4)

but this doesn't appear to put a value into B3 or B4 - it just displays a
value in C3 (presumably because it's evaulating B3=B3+1)

Thanks again

Fraser

PS I've had problems in getting Excel to place a value in a cell referenced
in a formula before and used Macros to get round it but for this exercise we
cannot use Macros.


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Running Totals

Well, you've failed to quote any of the content of the message to which you
are replying, so it's a bit difficult for us to advise on the specifics, but
the main point that you've got wrong is that you seem to be expecting a
formula to "push" a value into another cell.
A formula doesn't do that; it writes the new value into the cell where the
formula is sitting.
--
David Biddulph

"Pickup" wrote in message
...
Sean, Many thanks for the reply.

Sorry my omission - the question specifies that the results of each throw
should appear in a single cell (the throws are simulated by switching auto
calc off and then using F9 to generate a new number) with running totals
being kept for the count of heads & tails.

I think you mean B2 in your examples rather than C2 .. IF(C2="Yes"... ??

I tried something like this already unfortunately when the answer's no C3
would reset to 0. I also tried

C3, =IF(B2="Yes",B3=B3+1,B3=B3)
C4, =IF(B2="No",B4=B4+1,B4=B4)

and

C3, =IF(B2="Yes",B3+1,B3)
C4, =IF(B2="No",B4+1,B4)

but this doesn't appear to put a value into B3 or B4 - it just displays a
value in C3 (presumably because it's evaulating B3=B3+1)

Thanks again

Fraser

PS I've had problems in getting Excel to place a value in a cell
referenced
in a formula before and used Macros to get round it but for this exercise
we
cannot use Macros.






  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Running Totals

Hi David,

Thanks for the reply - I guess I'm in the habit of deleting extraneous info
and since it was listed in the previous posts thought it was superflous - I
take your point that it's easier for someone new to look at the most recent
post rather than go to the trouble of reading the first post.

I'm trying to keep a running total so yes I guess I am trying to push a
value into a cell. I know that other spreadsheet packages can do this but
I've never been able to find anything that states categorically Excel won't -
eternal optimist that I am I keep hoping this means that it can ;-)

Regards

Fraser

"David Biddulph" wrote:

Well, you've failed to quote any of the content of the message to which you
are replying, so it's a bit difficult for us to advise on the specifics, but
the main point that you've got wrong is that you seem to be expecting a
formula to "push" a value into another cell.
A formula doesn't do that; it writes the new value into the cell where the
formula is sitting.
--
David Biddulph

"Pickup" wrote in message
...
Sean, Many thanks for the reply.

Sorry my omission - the question specifies that the results of each throw
should appear in a single cell (the throws are simulated by switching auto
calc off and then using F9 to generate a new number) with running totals
being kept for the count of heads & tails.

I think you mean B2 in your examples rather than C2 .. IF(C2="Yes"... ??

I tried something like this already unfortunately when the answer's no C3
would reset to 0. I also tried

C3, =IF(B2="Yes",B3=B3+1,B3=B3)
C4, =IF(B2="No",B4=B4+1,B4=B4)

and

C3, =IF(B2="Yes",B3+1,B3)
C4, =IF(B2="No",B4+1,B4)

but this doesn't appear to put a value into B3 or B4 - it just displays a
value in C3 (presumably because it's evaulating B3=B3+1)

Thanks again

Fraser

PS I've had problems in getting Excel to place a value in a cell
referenced
in a formula before and used Macros to get round it but for this exercise
we
cannot use Macros.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
running totals DCOOPER Excel Worksheet Functions 1 June 20th 08 06:48 PM
need help with running totals chusu Excel Worksheet Functions 1 September 26th 07 11:11 AM
Running totals Carol A. Excel Discussion (Misc queries) 5 January 10th 07 10:48 AM
Running Totals MAC Man Excel Discussion (Misc queries) 5 November 8th 06 09:41 PM
running totals [email protected] Excel Discussion (Misc queries) 4 April 22nd 06 04:25 PM


All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"