Thread
:
Please help me decipher the result of COUNT.
View Single Post
#
4
Posted to microsoft.public.excel.newusers
Epinn
external usenet poster
Posts: 605
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
Reply With Quote
Epinn
View Public Profile
Find all posts by Epinn