Relative reference in Countifs

[theTaoJones]

I'm trying to count the number of cells that have values in excess of a 10% tolerance of another cell in its row.
I can't figure out how to make the Countifs function reference each row. I feel like this should be an array, but don't how how to set it up.

[davesexcel]

Here is a test,
In E2:E16 I have

=IF(ABS(B2-C2)<0.1,"ok","Nope")

Then in G2 I have< count the Nope's or ok's

=COUNTIF(E2:E16,"Nope")

[ChemistB]

Try using SUMPRODUCT

=SUMPRODUCT(--(D2:D16/B2:B16> 0.1))

[theTaoJones]

ChemistB,

Thanks. That mostly works, but in my actual data set I have some 0s in column B, which of course gives the #DIV/0! error. How can I get around that?

[theTaoJones]

I think I figured it out from ChemistB's initial solution:

{=SUMPRODUCT(--(D2:D16/IF(B2:B16=0,1,B2:B16)> 0.1))}

That may be overly complex for what I'm trying to do, but I'm running with it for now.

[ChemistB]

That works. Good job.