COUNTIF Formula hell

  • Thread starter Thread starter ianripping
  • Start date Start date
I

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!
 
Ian,

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

--
Regards,
Auk Ales

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