|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