COUNTIF with the criteria being less than referenced cell.

[jed_vii]

I have a list of numbers (which are ranks of another table) in B65:V65.

I want to be able to count the number of times one of these 21 values is above half the values. Each week I add another number So after 1 week there is only a value in B65, after two weeks there is a value in B65 and C65 etc. Each week I want to count the number of times a value is in the top half.

So I would like to have something like

=COUNTIF($B65:$V65,">($A$2/2)")

where A2 is the current week (currently 10). This is giving me fits because appearantly the COUNTIF doesn't allow the criteria to be a refernce. If I put the criteria as ,">($A$2/2)" I get a result of 0, but If I set the criteria to be ">5" then I would get 2.

Any help would be greatly appreciated.

-jed

[VBA Noob]

Maybe

=COUNTIF($B65:$V65,">"&$A$2/2)

VBA Noob

[oldchippy]

Try this,

=COUNTIF($B6:$V6,">"&$A$2/2)