COUNTIF criteria

[bikerhal]

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

 

[Pete_UK]

Do it like this:

=COUNTIF(A1:A5,">"&B1)

The condition is treated as if it were a string, hence the quotes.

Hope this helps.

Pete

 

[Mike H]

It works if you correct the syntax

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

Mike