View Single Post
  #4   Report Post  
Harlan Grove
 
Posts: n/a
Default

"Bob Phillips" wrote...
....
=SUMPRODUCT(--(A2:M2A1*90%),--(A2:M2<=A1*110%),A2:M2)

....

Or

=SUMPRODUCT(--(ABS(A2:M2/A1-1)<=0.1),A2:M2)