The excel SUM function can calculate the summary of number values in a cell range. But when you add a new number cell before or after the cell range, the SUM function can not add the dynamically added number in the result. This article will tell you how to sum dynamic range in excel.
