CountIf Dynamic

[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.

 

[bpeltzer]

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

 

[Mike H]

try

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

Mike

 

[JE McGimpsey]

One way:

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

 

[TG]

Thank you kindly!

try

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

Mike