SUMIF to add number of occurrences of same word

[john.fries]

Hello,

I have an employee status board to track training. I am trying to create a front sheet that gives a roll-up of different metrics inside the document.

Specifically, I am trying to count if each employee is qualified for a position which is labeled "Yes" or "No". I want to know how many employees are qualified for X position and how many employees are qualified in Y position, ETC. I've been trying to make SUMIF work for this, maybe I'm barking up the wrong tree here.

=IF(Status Board!$C:$C="NO",1,0)SUMIF(Status Board!$C:$C,'NO',Status Board!$C:$C)

[Tony Valko]

It sounds like you want to do a conditional count?

Maybe this...

=COUNTIF('Status Board'!$C:$C,"No")

=COUNTIF('Status Board'!$C:$C,"Yes")

[JieJenn]

Maybe use COUNTIF function instead of SUMIF

=COUNTIF($C:$C,"No")

[john.fries]

Perfect. Worked as needed. Thank you

[Tony Valko]

You're welcome. We appreciate the feedback!