I am trying to write a formula to calculate cost per foot (cell E13) I want the total in cell E12 to be divided by cell C8 if it has data if not move to cell C9, do this through C11. | ||||
Item | Quantity | Cost | Total | |
Corner post assembly | 8 | 90 | 720 | |
"H" assembly | 10 | 56 | 560 | |
Wood line post | 21.88 | 0 | ||
T post | 860 | 4.85 | 4171 | |
Fiberglass post | 7.28 | 0 | ||
3 Strand electric | 0.09 | 0 | ||
3 Strand Barbless | 0.16 | 0 | ||
4 Strand Barb | 0.21 | 0 | ||
5 Strand Barb | 14000 | 0.26 | 3640 | |
Total cost of material: | 9091 | |||
Matrerial cost per ft: |
<tbody>
</tbody>