Countif Help

  • Thread starter Thread starter Chris.Wheeler
  • Start date Start date
C

Chris.Wheeler

Could Anybody Please Tell Me Why This Statement Does Not Work? Any Help
Would Be Appreciated.

=COUNTIF(h(VALUE($R$2)):H(VALUE($R$3)),$A3)

The Value Of R2 is 266
The Value Of R3 is 301

Thanks
 
Chris

Try

=COUNTIF(INDIRECT("H" & $R$2 & ":H" & $R$3),$A3)

The Indirect allows the use of variables in declaring a range.

Dan E
 
Because you cannot use countif like that, this will work

=COUNTIF(INDIRECT("H"&R2&":H"&R3),A3)
 
Back
Top