Solved: Countif with a Range Name as the Criteria

[JimS]

I need a formula that will do this (this does not work):

=COUNTIF(B:M,>=High)

Where "High" is a single cell Range Name.

Not sure how to get it to do the "greater then or equal to".

Thanks for any help...

JimS

[Bob Phillips]

It needs to be concatenated and enclosed in quotes

=COUNTIF(B:M,">="&High)

[Aflatoon]

=COUNTIF(B:M,">="&High)
should work.

[JimS]

That still doesn't work.

The only thing that worked was =COUNTIF(B:M,High) but that only counts the equal to cells.

[JimS]

Aflatoon got it - Thanks to both of you for the help...

[Aflatoon]

You are most welcome!