I’m using the function =COUNTIF(B3:B82;">10") to count values in range B3:B82 that are greater than 10, but I’d like to compare the values to a specific cell (e.g. ">D8") and not a fixed number. Is that possible?
According to the Help for COUNTIF, yes. If you have a value in D8 to compare:=COUNTIF(B3:B82;">"&D8)
or if the actual formula is in D8, e.g. the text >12; =COUNTIF(B3:B82;D8)
If this answer helped you, please accept it by clicking the check mark 
to the left and, karma permitting, upvote it. That will help other people with the same question.
In case you need clarification, edit your question (not an answer) or comment the relevant answer.
That did it! Thank you very much. 