COUNTIF and Named Cells

[RBaskie]

I have a feeling I'm missing something obvious.

I have some data in columns, where folk have a number that indicates their skill level (0, 1, 2 or 3) in a task.

e.g.

Name Level
Jane 3
Bob 2
Emily 2
Rona 0
Molly 1
Brenda 3

I want to use COUNTIF (I think) to tell me how many people in the list are listed as Practitioner, which is level 2 or above.

It's straightforward when I use =COUNTIF($E$3:$E$22,">=2")

But I'd like to set a field in a different worksheet that sets PractitionerLevel to 2, so that I can change that and not have to amend my formula.

I tried just referencing the cell: =COUNTIF($E$3:$E$22,">=Control!H4") and naming the cell: ">=PractitionerLevel" but they always return 0.

I saw a similar post in the forum about dates, and the answer appeared to be to ensure the cell was formatted as a date. I have ensured my cells are formatted as numbers, but that didn't changes anything.

Any help greatly appreciated.

 

[Weazel]

try it like this...

=COUNTIF(E3:E22,">="&control!H4)

 

[FormR]

Hi, welcome to the forum.

You can try either:

=COUNTIF($E$3:$E$22,">="&Control!H4)

Or

=COUNTIF($E$3:$E$22,">="&PractitionerLevel)

 

[RBaskie]

Thank you so much - that's fixed it for me. Perfect!