I’m having trouble with an IF statement. I have a lookup column with two values, Turned or H/L. If the value is Turned, I want my formula to add the values in each of the shoe sizes listed. I’m getting an ERROR every time I try it though. Is it because the value (H/L) is a lookup value? The formula saves correctly, but the resulting value is #ERROR!