T
Texhun
I have developed a work order sheet for invoicing maintenance accomplished on
a fleet of aircraft. It consists of a series of 20 block of cells. Each block
of cells is one "item" detailing work accomplished, labor, parts, freight,
total item cost, etc. At the bottom of the sheet I have formulas set for work
order totals. So total labor is: =SUM(I9,I24,I39,I54,I69,I84, and so on until
I294). I have similar formulas for total parts, freight, etc. My problem is
that I want to delete the blocks of cells not used for a particular work
order. So if we used only 8 items, I want to delete item 9 thru 20. When I do
this, my totals formulas at the bottom of the sheet display an error message
because I deleted some of the cells in that formula. The cells I am totaling
are not next to each other so I cannot use a range of cells for the formula.
Is there a way to get around this? Many thanks in advance.
a fleet of aircraft. It consists of a series of 20 block of cells. Each block
of cells is one "item" detailing work accomplished, labor, parts, freight,
total item cost, etc. At the bottom of the sheet I have formulas set for work
order totals. So total labor is: =SUM(I9,I24,I39,I54,I69,I84, and so on until
I294). I have similar formulas for total parts, freight, etc. My problem is
that I want to delete the blocks of cells not used for a particular work
order. So if we used only 8 items, I want to delete item 9 thru 20. When I do
this, my totals formulas at the bottom of the sheet display an error message
because I deleted some of the cells in that formula. The cells I am totaling
are not next to each other so I cannot use a range of cells for the formula.
Is there a way to get around this? Many thanks in advance.