COUNTIF PROBLEMS AGAIN

[bartoni]

HI,

Im performing COUNTIF functions on ranges of data. Each data range consists of the first 2 letters of the country with an "h" on the end. I.e France consists of 3000 rows and is named FRH.

Ive got lots of data ranges and i need to put together some countif functions in a summary table. What I want to do is put a formula together that refences a cell which contains the name of the range

FRH = Cells B1:B3000

Cell A1 = FRH

I want my countif to read:

COUNTIF(A1, ">10")

How do i get it to read A1 since this cell contains the name of the range i want the formula to search?

Thanks

 

[fairwinds]

Hi,

Try:

=COUNTIF(INDIRECT(A1), ">10")

 

[Brian from Maui]

Hmmmm....

http://www.mrexcel.com/board2/viewtopic.php?t=178097

Hey fairwinds!

 

[fairwinds]

Hey Brian

I guess that question just vanished...

 

[bartoni]

I deleted it by mistake, I actually meant to delete my reply but the whole thing disapeered.