Counting totals based on other columns criteria

Hello!

Not sure if I'm using the wrong formula on this one or not, but the intent is simple.

I am creating an "at a glance" grouping of totals at the top of my sheet (cell C6, yellow cell as an example with the formula in the attached sample file). The intent is to have the total populated when a value of '100%' is entered in column C, and the totals will be sorted by the associated name in column F. Thus, if there are 47 Engineers that have 100% completed, then that 47 will appear at the top.


I'm not sure if a COUNTIFS, SUM, even a VLOOKUP, or something else would be best for this kind of task. My google-fu hasn't resulted in an answer just yet as I'm most likely not wording my search correctly. Probably doesn't help that I'll muck up the syntax on the formula either.

Thanks for any help!

EDIT:

I've been looking through other forums posts here and while some are similar to what I'm looking to do (counting based on multiple criteria), I'm starting to think I have an issue with how I'm handling my syntax.

=COUNTIFS(C:C, "100%",F:F, "Engineering") <=== is what I'm presently using however I think I'm missing something.

The formula in C6 does not work because your criteria is "Engineering" but in column F it is "Engineer"

You have "circular reference error" as you referencing column c (C:C) which itself contains your formula.

Change C:C to C16:C100 and F:F to f16:F100 (or whatever you max range will be)