Site Certified operator
1 yes
yes
no
2 yes
no
3 no
yes
4 no
no
Can anyone come up with a function that will count how many of the sites in column one have at least one "Yes" in the corresponding certified operator cells?
Sites can have multiple operators but any combination could be certified. If one site has 3 certified operators it should only count 1.
Answer for above example would be 3.
I've been struggling with this one for awhile, any help is greatly appreciated.
1 yes
yes
no
2 yes
no
3 no
yes
4 no
no
Can anyone come up with a function that will count how many of the sites in column one have at least one "Yes" in the corresponding certified operator cells?
Sites can have multiple operators but any combination could be certified. If one site has 3 certified operators it should only count 1.
Answer for above example would be 3.
I've been struggling with this one for awhile, any help is greatly appreciated.