View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Epinn Epinn is offline
external usenet poster
 
Posts: 605
Default Please help me decipher the result of COUNT.

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