View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MG
 
Posts: n/a
Default Adding specific cells in column

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