Can COUNTIF use a cell as a criteria reference?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=COUNTIF(B2:B6,"<D2")

This formula always returns the result "0". The cells are formatted as
dates. If I convert the range to numbers, and insert a number as the
criteria, I get the correct result.

1. Why can't I use a reference as criteria?

2. Why can' I perform the calculation on dates?

Thanks,

Steve Pretti
 
Back
Top