I am using the following countif() function on a range of cells =COUNTIF(D7:R7,">0")
My question is, I don't necessarily want to use 0, but would rather use a number that is in the same column but a different row for each value in D7:R7. In this example, the data is in row 5. How would I specify this in the criteria portion of the function? I tried =COUNTIF(D7:R7,">"&D5:R5) but that's not getting the job done.
Any ideas?
My question is, I don't necessarily want to use 0, but would rather use a number that is in the same column but a different row for each value in D7:R7. In this example, the data is in row 5. How would I specify this in the criteria portion of the function? I tried =COUNTIF(D7:R7,">"&D5:R5) but that's not getting the job done.
Any ideas?