Hi
have a look at COUNTIF for this

--
Regards
Frank Kabel
Frankfurt, Germany

"gi" schrieb im Newsbeitrag
m...
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.