Thread: CountIf Dynamic
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tg tg is offline
external usenet poster
 
Posts: 58
Default CountIf Dynamic

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.