View Single Post
  #5   Report Post  
Bob Phillips
 
Posts: n/a
Default

Yep, I buy that.

--

HTH

RP
(remove nothere from the email address if mailing direct)


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

...

Or

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