Count Occurences of a Cell If It's Less Than

[matthewlouis]

In my probability analysis spreadsheet, I have a single cell (E10) that contains a %. My goal is to create a counter where, on a mouse click, it will count the number of times cell E10 <=80%.

If I do 30 clicks, 40 clicks, just a simple set of iterations . . . I would like to see the cell count the times those clicks were less <=80%.

What would the formula look like for that?

Thanks in advance!

 

[matthewlouis]

I will update the algo with what you just posted . . . I have saved it as a macro-enabled workbook. Same thing as .xlms ?

OK, now it's calculating and recording. However, I have to keep hitting Esc to get to calculate, i.e., I have to hit it 100 times. But it is counting now and my numbers are changing. But it is not automatic. But it's a lot better than what I had! Any way to make it automatic?

 

[JamesCanale]

macro-enabled is right.

When it runs, it should fill up the Immediate window, and this latest one will pester you with pop up messages counting up to 100. If that isn't happening, the macro isn't running.

 

[JamesCanale]

Get rid of the MSGBOX line - it will be less pesty.

 

[matthewlouis]

Get rid of the MSGBOX line - it will be less pesty.

Hmmmm, got rid of the MSGBOX line and it stopped calculating again. Went and put it back in and it's calculating. I just hit Esc 100 times and it calculates and counts. The Immdiate box looks great, it's full all the way to 100. I also noticed I cannpt have Excel in auto cal mode or it does have the pesky pop up messages. Manual only works an. So, it's working with the MSGBOX line just doesn't do it automatically.

 

[matthewlouis]

Yeah, I took MSG line out, put excel on autocalculate, hit the macro and no calculations again, just counts to 100.

 

[JamesCanale]

So if you type a number into any cell in your spreadsheet, does your random numbers change? Sometimes I hold delete on an empty cell and I watch all of the random numbers change in the spreadsheet. Is that happening? It's an oddity to me.

 

[matthewlouis]

So if you type a number into any cell in your spreadsheet, does your random numbers change? Sometimes I hold delete on an empty cell and I watch all of the random numbers change in the spreadsheet. Is that happening? It's an oddity to me.

"If I type a number into any cell . . ." Well, I have to keep the autocalc OFF and manual ON because I keep getting stopped on those pesky pop ups if I leave the autocalc on. So, if I am not running the acro, I hit F9 to change my numbers. If I hold delete on an empty cell, it doesn't do anything.

 

[matthewlouis]

Hey James, did you see my response to your last post?