COUNTIF Formula hell

[ianripping]

Hi. I am trying to set up a formula that uses a standard COUNTIF
function, but I want the Range to be pulled from two other cells.

Eg. The cells B2 AND B3 have The Cell Numbers "A1" and "A3" in them
respectivley.

I want the COUNTIF function to look at B2 and B3 and then realise that
the Range it needs to look between in A1 and A3.

I have tried to create a function to do this and could only think of:-
COUNTIF((B2)B3),"Apple")

which doesnt work. Any ideas?

If confused please ask because Its A bitch to explain!

 

[Andy B]

Hi

Try this:

=COUNTIF(INDIRECT(B2):INDIRECT(B3),"apple")

Andy.

 

[A.W.J. Ales]

Ian,

COUNTIF(INDIRECT(B2 & ":" & B3);"Apple")

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[ianripping]

Excellent! Both worked. Thankyo