I have a process that generates the value X in cell A1 randomly. So I can change the value of X in A1 by clicking on F9. I want to sum a sequence of X values. I can do this by manually copying each X to a row of cells and then summing the row values. But that is tedious. Can the summation be done automatically without being regarded as being circuler?
I have attached a workbook that accomplishes what you ask via a button and macro. When you click the button, it will generate a random number in cell A1, and add that random number's value to the total in B1.
The first time you click it, the values will be identical. Once you click it a second time, a new random number will be placed in A1, with it's value added to the current value in B1. Hope it is what you were looking to do.
- Moo
another option is just to repeat what's in a1 so if you wanted to find out how many times "x" is generated after say 100 f9's
just fill down 100 rows and countif(a1:a100,"x") press f9 once random is random after all
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
See this...
http://mcgimpsey.com/excel/accumulator.html
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Moo
Thank you for that. I have downloaded it and used it in a trial. However, the value I have in my A1 is produced by a calculation using a list of random numbers and a new calculation is carried out when I click F9. Clicking your button just generates a random number in A1 but does not carry our my calculation. How do I link the two? I copied your Random Number Addition to my workbook but this did not copy the button so I could only try out the down load.
If I repeat (copy) A1 to a column of cells, every time I press F9, every cell in the column gets the new value in A1. Am I misinterpreting your instruction?
Thank you, Tony Valko
I will learn about macros so I can address my problem
You're welcome. Thanks for the feedback!
just to reiterate putting randbetween(1,15) in a1 then pressing f9 100 times to see how many times say 6 comes up
then counting each time so in 100 presses of f9 you get 12 lots of 6 so the answer is 6 came up 12 times
is just the same as putting randbetween(1,15) in cells a1:a100 press f9 once then count how many of those are 6
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks