That will work if H3 contains a reference to your criterion (e.g., H3
contiains "J1" where cell J1 contains "W").

If your criterion is *in* H3 (i.e., H3 contains "W"), use

=COUNTIF('FLYING TIMES'!F4:F22, H3)

In article ,
"Malcolm Austin" wrote:

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..