Okay, I was thinking along those lines as well. Thank you

"Jim Thomlinson" wrote:

It looks like you are wanting the values form every second column. If the
values inbetween are not numbers then you can just specify the entire range
like this (countif requires that the range be contiguous)

=IF(V2 < 0.1, 0, COUNTIF(D2:R2, "=6"))

Otherwise I would be inclined to either re-arrange the data to be contiguous
or create a new contiguous section on the sheet (which you can hide)
refereing to D2+F2+H2+J2+L2+N2+p2+R2
--
HTH...

Jim Thomlinson


"Nash13" wrote:

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