Countif Help

[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

 

[Dan E]

Chris

Try

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

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

Dan E

 

[Peo Sjoblom]

Because you cannot use countif like that, this will work

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