Logical check working some of the time

No ladder size in your image

D4 is not equal to H4, so result is correct. Same for D5 and E5.

In principle, the first 2 are wrong, because only some of the criteria in the AND function are met. All 4 rows should return -1. The correct result in the first 2 rows is coincidence.

Please attach a sample workbook, not image. Type in the expected results and explain to us how you got those results.

Originally Posted by FDibbins

Not really sure why you are even using SUM, when you want a value for that row only?

Perhaps this will simplify it though...
=sumifS(F$2:F$5,D$2:D$5,H2.E$2:E$5,H$1)

AND wont work like that with a range, you need to compare 1 cell with 1 cell

This is exactly what I was trying to do. That solved my problem. Thank you so much for helping me out!!

Originally Posted by Sc0tt1e

=IF(COUNTIFS(H2,D2,E2,0.75)>0,SUM(D2*F2),0)

I think that's what you want, put this is I2 and run the formula down to I5 and it will work for each line

Not quite what I'm looking for but still an interesting way of doing it!
The formula you supplied gives me the quantity x size. So if I have two 5.5, it will output 11.
Thanks again for the reply!!