software

The lines are detailed by person and detail for each person, then a line for
budget and a line for actuals. The columns are by date then sumarised by
month.
Along the bottom I want to add up a total for all the budget lines and all
the actual lines. But I want the formula to remain intact if additional
lines are inserted or deleted.
ie b5 b10 b15 etc (and cell a5,a10,a15 = budget) the same for the actuals
thanks
--
MG

MG

use SUMIF

=SUMIF($A:$A,quot;budgetquot;,$B:$B)
=SUMIF($A:$A,quot;actualquot;,$B:$B)

Not sure what you mean by quot;along the bottomquot;. You could *not* put these
formulae in column A or B. But, say you used cells A1 to B30, you could put
the formulae in C31 and D31 ... anywhere you like, in fact, below or
alongside the data

Regards

Trevorquot;MGquot; gt; wrote in message
...
gt; The lines are detailed by person and detail for each person, then a line
gt; for
gt; budget and a line for actuals. The columns are by date then sumarised by
gt; month.
gt; Along the bottom I want to add up a total for all the budget lines and all
gt; the actual lines. But I want the formula to remain intact if additional
gt; lines are inserted or deleted.
gt; ie b5 b10 b15 etc (and cell a5,a10,a15 = budget) the same for the actuals
gt; thanks
gt; --
gt; MG