EXCEL - COUNTIF Function 2

[susejdrol]

Team,

Is there a way to use the countif function and refence another cell. In other words, to ask EXCEL to count all of the cells in a range whose value is less than or equal to the number in cell B4.

For some reason, I can only get it countif to work if I specify the value in the condition, ie. =countif(C6:H6,&quot;<7&quot

It alwaus counts zero if I say =countif(C6:H6,&quot;<L4&quot

Any ideas.

Thanks

CP

 

[ETID]

=COUNTIF(C6:H6,&quot;<&quot;&L4)

 

[susejdrol]

That worked perfectly. Thanks a million.

CP