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?

Name Range called _Title
CFO	Tyler	CFO
CEO	Justin	CEO
CTO	Courtney	ATO
ETC	Jill	C3P0

<tbody>
</tbody>

 

[Ron Coderre]

Try something like this:

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

Is that something you can work with?