Hi Steve,

Thank you for pointing out the obvious. I misread the last formula as cells
containing numbers that have a 2. I find it "strange" to add on a value to
the no. of occurrences returned. Care to give an example?

The following link should be good read for me.

http://office.microsoft.com/en-us/as...266271033.aspx

Guess the game show has nothing to do with Sudoku.

Cheers,

Epinn

"SteveW" wrote in message
news:op.ted8ggxnevjsnp@enigma03...
yes it is from count's help

but the examples show that it is *not* counting the actuall figure 2's
It also shows count(a1:a7) results in 3
so that plus the 2 gives 4

Steve



On Wed, 16 Aug 2006 21:01:05 +0100, Epinn
wrote:

I did check out help.

My original post was the result of reading help.

If you check help, you will notice that the example I used was from help.
May be you talk about a different "count."

Sorry I asked.

Epinn

"Don Guillett" wrote in message
...
have a look in the help index for COUNT

--
Don Guillett
SalesAid Software

"Epinn" wrote in message
...
Following data from A1:A7

Sales
12/8/2008

19
22.24
TRUE
#DIV/0!


=COUNT(A1:A7,2) returns 4.

I don't understand where the four occurrences of 2 come from.

22.24 = 3 occurrences
12/8/2008 = 2 occurrences
total of 5??

I know I am missing something. Please tell me.

Is there a tool that I can use to trace? I tried the formula auditing
toolbar, no luck because there is no error and trace precedents is not
detailed enough.

Appreciate explanation.

Epinn









--
Steve (3)