Summing Cells together - How do I exclude anything within parentheses?

[chenowethtruss]

I'm creating a pricing document for deliveries (if that helps). I need to only include the pricing outside of the parentheses in Column9 - Surcharge Fee (I3) (excluding the milage shown within) to add it to the rest of the delivery charge in Column 5. I am unclear on what I should be instructing other than C4+D4+F4 & then Colum9 is I3 & I am lost on how to go from there. I'm sure this is elementary for most; but I seem to only be finding videos that explain how to only extract & add the information from within the parentheses and feel like I am stuck down a rabbit hole. And an advance Thank you! for anyone that can give me a workable suggestion.

Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9
Job #	# Of Deliveries	Professional Service Fee	# of Load/Unload Fees	Total Miles	Cost Per Mile	Fuel Surcharge Type	Delivery Range	Surcharge Fee
19404​	1​	No	0​	160​	3.23​	Premium	151-200	$158.00 (151-200)
		0​	0​	160​	516.8​
			Total Delivery Charge	#REF!​

 

[Snakehips]

@chenowethtruss Welcome
One way to extract the value from text of that specific pattern would be as below.

Book1
	I
3
4	$158.00 (151 - 200)
5	158.00
Gradings_2

Cell Formulas
Range	Formula
I5	I5	=IFERROR(MID(I4,2,FIND("(",I4,1)-2),"")

Hope that helps.

 

[rlv01]

One example.

Book1
	C	D	E	F	G	H	I	J	K
1	Service Fee	Load Unload Fee	Total miles	Cost/Mile	Mileage Charge		Surcharge Fee	Just the Number	Total Fee
2	10	20	160	3.23	516.8		$158.00 (151-200)	158	704.8
Sheet1

Cell Formulas
Range	Formula
G2	G2	=F2*E2
J2	J2	=VALUE(LEFT(I2,FIND("(",I2)-1))
K2	K2	=C2+D2+G2+J2

 

[chenowethtruss]

Thank you to both of you. Both solutions work just fine. I appreciate your assistance.