INDIRECT WITH COUNTIF

[Malcolm Austin]

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

 

[JE McGimpsey]

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)

 

[Malcolm Austin]

Hi,
yes my criteria will be in H3 (or other) so this should work fine
for me.

Many thanks, Malcolm...