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

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

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

Many thanks, Malcolm...


"JE McGimpsey" wrote in message
...
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..