PDA

View Full Version : Solved: Countif with a Range Name as the Criteria



JimS
10-13-2009, 08:32 AM
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
10-13-2009, 08:54 AM
It needs to be concatenated and enclosed in quotes

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

Aflatoon
10-13-2009, 08:56 AM
=COUNTIF(B:M,">="&High)
should work.

JimS
10-13-2009, 09:01 AM
That still doesn't work.

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

JimS
10-13-2009, 09:03 AM
Aflatoon got it - Thanks to both of you for the help...

Aflatoon
10-13-2009, 09:05 AM
You are most welcome!