I could tomorrow but it will take me some time to remove the privacy stuff but I'm really close right now.
What I'm doing is inserting a column next to the column I'm trying to calculate with this formula.
Code:
=IF(C3="2x", 45, IF(C3="3x", 45, IF(C3="4x", 45, IF(C3="5x", 45, IF(LEFT(C3,1)="Y", 30, 40)))))
The problem is, it's still giving me a 40 when the field is blank (this product not ordered for that person) and I don't know how to say do nothing if the field is blank.
Once I get these columns to work I can hide them and put their total underneath the row I'm calculating.