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
Bookmarks