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 |
Adding specific cells in column
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 |
All times are GMT +1. The time now is 09:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com