Counting using Name Manager

[tycasey17]

I have a name range called "_Title" with the following titles in it. Tyler and Justin meet the criteria to be counted, I've tried using =COUNTIF but it always comes back as 0. What formula do I need to use to be able to count these individuals?
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name Range called _Title[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CFO[/TD]
[TD]Tyler[/TD]
[TD]CFO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CEO[/TD]
[TD]Justin[/TD]
[TD]CEO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CTO[/TD]
[TD]Courtney[/TD]
[TD]ATO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ETC[/TD]
[TD]Jill[/TD]
[TD]C3P0[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Ron Coderre]

Try something like this:

=SUMPRODUCT(COUNTIF(C1:C4,_Title))

Is that something you can work with?