Posted to microsoft.public.excel.worksheet.functions

Anat27

external usenet poster

Posts: 3

Count in a cell, not an array

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If, Count & Array	Bec[_3_]	Excel Worksheet Functions	2	April 23rd 08 05:45 AM
COUNT and IF Array	bob	Excel Worksheet Functions	3	December 2nd 07 03:08 PM
Count & Array Function	Scott Halper	Excel Worksheet Functions	4	March 23rd 07 05:27 PM
Count If Array Formula	carl	Excel Worksheet Functions	2	November 21st 05 08:52 PM
Count if array contains cells of a certain value	Melissa	Excel Worksheet Functions	2	July 29th 05 02:37 AM

All times are GMT +1. The time now is 08:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us