It works if you correct the syntax :)

=COUNTIF(A1:A10, ""&B1)

Mike

"bikerhal" wrote:

How do I use COUNTIF (or SUMIF) where the criteria is of the form X and the
value of X is contained in a cell?

For example, COUNTIF(A1: A5, B1) does not work in Excel 2003

Thanks