Basically, I need a function that simulates this one but actually works:

=countif(a3:m3,>af3)

with af3 being a cell that is based on a manipulation of a3:m3.

I know I can do =countif(a3:m3,">n") but that cannot autofill down (which it will need to do for 50,000+ rows).

It can be done in vba, but I would really like to keep the function in the worksheet.

Essentially count the number of cells in a range that fit a criteria based on another cell.


thanks in advance
Chris