INDIRECT WITH COUNTIF
Hi, I'm sure this is a simple one, but my one remaining brain cell can't
see it!
My formula currently is:- =COUNTIF('FLYING TIMES'!F4:F22,"W")
What I want to do is use a cell reference where the "W" is now.
Something like:- =COUNTIF('FLYING TIMES'!F4:F22,INDIRECT(H3))
Working in Excel 2000 SR1
Can anyone put me right please?
Thanks, Malcolm..
|