Adding specific cells in column

[MG]

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

[Trevor Shuttleworth]

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" <[email protected]> wrote in message
news:[email protected]...
> 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