Adding specific cells in column

M

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
 
T

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
 
Top