Count in a cell, not an array

[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

 

[Bob Phillips]

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)

 

[Anat27]

Sorry...but i don't really understand.. (i'm new at this...)

 

[Bob Phillips]

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)

 

[Anat27]

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!

 

[Bob Phillips]

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)