Hi!

I need help with a formula if anyone can extend a hand it would be greatly appreciated!

I have taken different measurements in feet and inches. I'd like to add all of these measurements and spit out a number in feet and inches so I know what the total linear foot is. I then would like to multiply this subtotal by 10% and come to a final linear foot measurement.

How do I go about doing this? Currently I have added A2:A14 to get 199 Feet and added C2:C14 to get 75 Inches. Which is 205' - 3" before a 10% increase.

Also, how would this formula be different if I was to find a square footage, not just linear footage?

See my table setup for Linear Footage:

pwJ4IRm.jpg