Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

EXCEL - COUNTIF Function 2

Status
Not open for further replies.

susejdrol

Technical User
Apr 24, 2003
32
US
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
 
That worked perfectly. Thanks a million.

CP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top