Thank you Sandy. If you read my response to Steve, you will note that I
have misinterpreted the formula. I wasn't trying to do countif. I also
misinterpreted when you mentioned the two date systems. I was making things
more complicated than they should have been. It's just not my day. Looking
at the bright side, all this misinterpretation allows me to learn extra
stuff. Thank you for explaining.

Epinn (two n's)

"Sandy Mann" wrote in message
...
Epin,

The date only LOOKS like it has a 2 in it. A date is a count of the
number
of days since 1/1/1900 - reformat the date as General and you will see the
data that is really stored in the cell, it will either be 39672 or 39790
depending on whether the date is mm/d/yyyy or dd/m/yyyy. (Always assuming
that you are not a Mac user.) It looks like a date because of the
formatting but the formatting is just a mask to make the underlying data
look the way you want it to.

It seems that you are trying to use COUNT() like COUNTIF()

=COUNT(1,2,3,4) will return 4 because it is counting the four numbers.

Therefore with numbers in A1:A3
=COUNT(A1:A3,4) will return 4 because it is counting the three numbers in
A1:A3 AND the number 4 in the function. It is NOT trying to count how
many
number 4's are in A1:A3

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Epinn" wrote in message
...
Don't know what you are talking about. I am trying to learn how to
count.

I have to figure out how to get a 2 by converting the date.

Epinn

"SteveW" wrote in message
news:op.ted7ebr8evjsnp@enigma03...
Your trying to invent one of those UK TV maths quizes aren't you ?

Steve


On Wed, 16 Aug 2006 20:37:24 +0100, Epinn
wrote:

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)