I am using excel 2007 and wish to create a formula for summing a column without having to create a new formula in each cell and a new one each time I make a new entry for a new cell in the same column. Is there a way to total all of column E for example including each new cell created in the column E?
excel
- Thread starter nashr1928
- Start date
strollin
Well-Known Member
pick a cell and enter the formula =sum(e1:e2500). Now as numbers are entered into the rows in column E they will automatically be summed. If need be the e2500 spec can be larger or smaller depending on how many numbers you expect. If the values in col E are derived from a formula, they will still be summed.
Good evening nashr1928
If your total is not in column E, then you could just use =SUM(E:E), which would add up all of column E, even as new numbers are added. Just be aware that you can't use subtotals in column E, or you would end up either double counting, or with circular formula errors.
HTH
DominicB
If your total is not in column E, then you could just use =SUM(E:E), which would add up all of column E, even as new numbers are added. Just be aware that you can't use subtotals in column E, or you would end up either double counting, or with circular formula errors.
HTH
DominicB