Formulas - Totals

Excel Tips 1 - Formulas - Total


Everybody uses “totals”, right? See the example image. Most users would create the total on row 3. If they need to expand to insert more rows, generally they would tend to insert above row 3. This may result the total excluding the new rows (unless Excel XP is used). To overcome this problem, always create the total in row 4, leaving a blank row above the total. Resize the row height as shown above and if you need to insert more rows, insert above the blank row (ie. row 3). By the way the formula for the total would be =sum(a1:a3) Simple huh?