Thread
:
SumIf Criteria Matches
View Single Post
#
4
Harlan Grove
Posts: n/a
"Bob Phillips" wrote...
....
=SUMPRODUCT(--(A2:M2A1*90%),--(A2:M2<=A1*110%),A2:M2)
....
Or
=SUMPRODUCT(--(ABS(A2:M2/A1-1)<=0.1),A2:M2)
Reply With Quote