title: formula for comparing columns with tolerance in Excel
body: <p>I'm saerching for a formula comparing two columns f and g with h and i taking a tolerance into account. I have coordinates f and g and coordinates h and i and I want to know how often f equals or is simlar to h and g to i here with a tolerance of 2. But both criteria Need to be met for the Count.</p>
  
  <p>I've tried things like this without succes:
  =SUMPRODUCT((F:F=H:H)<em>(G:G=I:I)</em>(F:I>0))/4</p>
  
  <p>=SUMMPRODUCT(((ABS(F:F)-(H:H)&lt;=2))<em>(ABS((G:G)-(I:I)&lt;=2))</em>(F:I>0))</p>
  
  <p>COUNTIF didn't work at all.</p>