If I understand your question correctly:
=COUNTIF($E$6:$E$2725,"=" & J47)-COUNTIF($E$6:$E$2725,"=" & K47)

"TG" wrote:

How can I use the CountIf dynamically?

COUNTIF($E$6:$E$2725,"= J47")-COUNTIF($E$6:$E$2725,"= K47")

Where J47 and K47 are numeric cell references. If this isn't possible, how
can I count a column of values in a user defined range.

Thank you very much.