Mixing row and column equations
I'm trying to set up a grid to work as an indented parts list / bill of materials. Here's a picture of where I'm at right now. Some things work fine. Others don't. Here's a picture:

I'm trying to figure out how to merge the row-level equation that sets Total Cost = Quantity Required * Cost Ea. with the column equation that sets Total Cost = sum (children)
Ideally, I would like to be able to enter a column equation for Cost Ea. that is the sum of the children's Total Cost columns. Then I can see the cost for a single sub-assembly as well as the total cost for the number of sub-assemblies required. If I do this, then Total Cost is always = Quantity Required * Cost Ea., and the Cost Ea.
- Read more about Mixing row and column equations
- 11 comments
- Log in or register to post comments