Board index » Excel » counting the number of ticks

Excel219
Hi to all excel Gurus:

I was hoping some could help me. I've created a financial model using

spinners to change values in a single cell and it produces an output

in another cell stating if I go bankrupt (simple "yes" or blank).

Now, I have set up my model so that I can use the spinner to go

through a 1000 trials. Right now, I've been physically counting the

number of "yes" that comes up. Is there a way I can have excel

automatically track the number of times "yes" comes up as I spin

through a 1000 trials. Thank you.


-

Hi

have a look at COUNTIF for this



--

Regards

Frank Kabel

Frankfurt, Germany



"gi" <leeg3@rpi.edu>schrieb im Newsbeitrag

-

Hi,



Not sure I understand, but if you are using a SpinButton you can use the

button's Change event to read and record the results. Here's a small example:



'-----

Option Explicit

Dim yCount As Integer

Private Sub SpinButton1_Change()

If Range("A1").Value = "Yes" Then

yCount = yCount + 1

Range("B1").Value = yCount

End If

End Sub

'-----



HTH

Anders Silven



"gi" <leeg3@rpi.edu>skrev i meddelandet

-