CountIf Dynamic

  • Thread starter Thread starter TG
  • Start date Start date
T

TG

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.
 
If I understand your question correctly:
=COUNTIF($E$6:$E$2725,">=" & J47)-COUNTIF($E$6:$E$2725,">=" & K47)
 
Back
Top