Hi
I would strongly recommend not to use this syntax :-)
You may run into trouble using this (COUNTIF has problems with the used
range in combination with this comparison).

To show this error try the following:
- open a new, frsh workbook
- enter the following formula in B1:
=COUNTIF(A1:A5;"<")

the expected result would be '0'. Though this generate for me the
result of '1'!


--
Regards
Frank Kabel
Frankfurt, Germany


Another less elegant response. Frank's answer is much more
appropriate.

=COUNTIF(H1:J5,"<")

Essentially, count if the cell is not equal to nothing.

K


---
Message posted from http://www.ExcelForum.com/