View Single Post
  #1   Report Post  
Malcolm Austin
 
Posts: n/a
Default 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..