Count in a cell, not an array

  • Thread starter Thread starter Anat27
  • Start date Start date
A

Anat27

Hi all, I have a cell that its value is changing all the time. i.e., each 10
seconds, mark TRUE. I want to count the number of times TRUE appears in the
cell. How can I do it?

Thanks a lot
 
Do it in the code that is updating the cell.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
What I mean is that there must be some code that is generating the changes
to that cell, so count at the point where the change is effected.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
First of all, thanks a lot for all the help... but as I still don't really
get it (usually i'm noy that stupid...really...), here is an exemple of what
I mean:
I have a cell: =if(mod(A1,5)=0,TRUE,FALSE).
This cells takes the data from another cell which is a clock showing the
values of seconds (so every 5 seconds I get a TRUE).
Could you show me how to make a cell which will count all the times TRUE
appeared?

Thanks a lot, really!
 
Okay, so what is driving the clock cell, what makes it change?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top