countif with variabel criteria?

[Hans]

Hi,

I'm blocked on a most likely very simple issue: I'm trying to have the
criteria in the countif function refer to a cell, so that the formula gives a
different result when that cell value is changed. I'm trying to compare
times in the [hh]:mm:ss format, and the 1904 date system is checked.

A B
17:05:33 20:00:00
20:19:22
32:53:00

formula's I've tried:
=countif (A1:A3,<B1)
=countif(A1:A3,"<B1")

Neither of them works apparently. Maybe I should be looking at another
function?

Thanks!!

 

[Bernard Liengme]

Try =countif(A1:A3,"<"&B1)

 

[Hans]

Works like a charm! thx.

Try =countif(A1:A3,"<"&B1)
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

Hi,

I'm blocked on a most likely very simple issue: I'm trying to have the
criteria in the countif function refer to a cell, so that the formula
gives a
different result when that cell value is changed. I'm trying to compare
times in the [hh]:mm:ss format, and the 1904 date system is checked.

A B
17:05:33 20:00:00
20:19:22
32:53:00

formula's I've tried:
=countif (A1:A3,<B1)
=countif(A1:A3,"<B1")

Neither of them works apparently. Maybe I should be looking at another
function?

Thanks!!