I am sure there is a much easier way to skin this cat but I think I have liftoff. This gives me the value I need in the column I'll be hiding. I can then make them sum into the visible cell with the total price.
Code:
=IF(C3="2x", 45, IF(C3="3x", 45, IF(C3="4x", 45, IF(C3="5x", 45, IF(LEFT(C3,1)="Y", 30, IF(ISBLANK(C3), "", 40))))))