Count in a cell, not an array
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" wrote:
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" wrote in message
...
Sorry...but i don't really understand.. (i'm new at this...)
"Bob Phillips" wrote:
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" wrote in message
...
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
|