I am trying to figure out how much dirt we are going to have to remove per structure. A structure consists of 2 holes with different amounts of soil being removed from each hole.
For example: I need structure 3 that has a right hole with 4.5 cy of soil to be removed and a left hole with 3 cy of soil to be removed. I want it so that a formula that I can easily transfer will combine the 2 lines into one quantity of soil that needs to be removed.
I have tried adding them, using summation, breaking up the numbers, and using the fill handle but it doesn't pick up on the pattern. Any ideas on how to do this efficiently? Thank you very much.