Sorry that is to say, when checking the condition, right now it's look at the entire column rather than the individual cell. So every result will only see the first item and use that as a reference. That's my guess!

Have you tried doing the formulas on a per row basis rather than the entire column? Something like, SUMIF(H2... etc