This formula won't change when I hit F9 to randomize it. I need the formula
to work when I change the numbers.
--
~Laura~


"Bob Phillips" wrote:

=IF(MIN(IF((A1:A20=0)*(A1:A20<""),ROW(A1:A20)))=0 ,ROWS(A1:A20),MIN(IF((A1:A
20=0)*(A1:A20<""),ROW(A1:A20))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"daydreamin7" wrote in message
...
I am trying to find a way to count cells in a range, I want them to count
numbers greater than 0. But when I hit the first 0 (I have it on
randomization), I want it to stop counting... because the game is over for
the simulation I'm dong. Any ideas what I can do?
--
Thanks,
~Laura~