Dear readers, today we will learn how to use multiple methods for SUM formulas in Excel?

Use the SUM function in Excel to add a series of cells, an entire column, or non-contiguous cells. To create awesome SUM formulas, combine the SUM function with another function.

Download the excel demo file here for SUM Formulas in Excel

Example for Sum Entire Column in Excel

sum entire column

Example for AutoSum in Excel

Use autosum or press ALT + = to quickly sum a column or row.

Step 1. First, select the cell below the column of numbers (or next to the row of numbers) you want to see.
Step 2. On the Home tab, in the Editing group, click AutoSum (or press ATL + =) and Enter

Example for AutoSum in Excel

Example for Sum Range of Cells in Excel

follow the picture

Example for Sum Range of Cells in Excel

Example for SUM function in Excel to sum non-contiguous cells

Non-contiguous means not next to each other.

SUM function in Excel to sum non-contiguous cells

Example for Sum Every Nth Row in Excel

The SUM formula below uses the SUM, MOD, and ROW functions in Excel to sum each nth row. Change 3 to 4 to sum every 4th row, 5 to sum every 5th row, etc.

Sum Every Nth Row in Excel

Example for SUM and the IFERROR function in Excel to sum a range with errors

The SUM formula below uses the SUM and IFERROR functions in Excel to sum a range with errors. You can use the AGGREGATE function in Excel to sum a range with errors.

Sum Range with Errors