Excel - Countif applied with Concatenation of Text

Giganews Newsgroups
Subject: Excel - Countif applied with Concatenation of Text
Posted by:  TKT-Tang (tkt_ta…@hotmail.com)
Date: 5 May 2004

1. Look at a worksheet ; the range A1:A10 is filled with text data.

2. Enter into cell C1, = Countif(A1:A10,"<="&A1:A10) ; it works.

3. Then, the range B1:B10 is filled with text data.

4. Enter into cell C2, = Countif(A1:A10&B1:B10,"<="&A1:A10&B1:B10) ;
it does not work.

5. Please offer an explanation that it does work and then it does not
work.

6. Regards.

Replies