HLOOKUP and SUM
Hi, Brian-
With your sample data in A1:D3 I got the right results with this
formula:
=SUMPRODUCT(--(A1:D1<=3),A3:D3)
The plain English translation is: "if the value in A1:D1 is less than
or equal to 3, sum the corresponding values in A3:D3".
Dave O
|