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,"budget",$B:$B)
=SUMIF($A:$A,"actual",$B:$B)

Not sure what you mean by "along the bottom". 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

Trevor


"MG" wrote in message
...
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