Okay, I lied. The sheet has gotten more difficult. This is essentially what
we are trying to do now but doesn't actually work.

=IF(V2 < 0.1, 0, COUNTIF(D2+F2+H2+J2+L2+N2+p2+R2, "=6"))


"Jim Thomlinson" wrote:

Try something like this...

=IF(E2 < 0.1, 0, COUNTIF(A2:C2, "=6"))
placed in H2
--
HTH...

Jim Thomlinson


"Nash13" wrote:

Hello,

I would like to see if someone can help me with this calculation. If cell E2
is 10% or above, we would like cell H2 to add one for each cells of A2, B2
and C2 that have a score of 6 or higher.

Essentially:

If: A2=6, B2=6, C2=5 and E2=10% then H2=2.
And: A2=6, B2=6, C2=6 and E2=10% then H2=3

Thank you