Have a look at my post 12. Is this what you're asking about? In which case, are you able to say what needs more explanation.
=COUNTIF(L2:L10001,>0) this returns an error
I checked the syntax for this function and found this example:
=COUNTIF(B2:B5,">55")
Counts the number of cells with a value greater than 55 in cells B2 through B5. The result is 2.
So try adding the ""s
Bob
]]>Welcome to the forum.
Just let me say this:
I sure wish someone would send a memo to the instructor who is using that as an exercise to teach his students the "the joys of programming."
Someone should tell him that is a horrible example or a great example of the misuse of a simulation. I would like to give him a piece of my mind so to speak. Nothing important, maybe just the medulla oblongata. Or maybe my left brain since according to Duke University, neanderthals like me never use it.
According to the ZAA, the left brain when viewed under the microscope is made up of tiny i's with little hearts over them while the right brain smells like old socks and gym shorts.
]]>It is mixed in to that thread, you will have to read the posts to find the relevant information and links.
Also there was information in the beginning of this thread from phrontister and bob bundy.
]]>That problem is posted in another thread if you want to see an excel simulation. What type of solution are you looking for?
]]>You are going to play a game where you bet a dollar and get to flip a coin ten times. If you get four heads in a row, you win. If you make the tenth flip without getting four heads in a row, you lose. Run this game ten thousand times. Approximately what is the probability that you will win?
]]>The Fourth?
Either that's today's date, or I've developed a bad spelling lithp.
]]>Have a good night.
]]>...and may the M be with you.
And May the Fourth be with you!
Yes...that Tuples command is interesting, generating all those possibles like that. Length was new to me too, and I didn't know about the use of "//" either. So...thanks for introducing them.
Early to bed for a change. Catch you later.
]]>