how to count attributes across multiple criteria

Good morning,

I am trying to create a nested countif formula. I want to count number of attributes from different column where some has different requirement

For example:

meow.JPG

but Reliable and Loyal should only get one point

Paste the following formula in C3 and copy down:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.