Download Practice Workbook
Method 1 – Use Arithmetic Formula
Steps:
- Go to cell C12 and insert the formula.
=C5+C6+C7+C8+C9+C10+C11We have entered the individual cells and added them to get the sum.
- Press ENTER to get the result.
Read More: How to Sum Columns in Excel (7 Methods)
Method 2 – View the Sum of a Column in the Status Bar
Steps:
- Left-click on the column to highlight it.
- Go to the status bar and you will find the Sum of the column.
Method 3 – Apply the AutoSum Feature
Steps:
- Go to cell C12 and navigate to the Home tab >> choose AutoSum from the Editing group >> pick ∑Sum.
The result will be displayed as shown below.
Read More: How to Sum Selected Cells in Excel (4 Easy Methods)
Method 4 – Utilize the SUM Function
Steps:
- Go to cell C12 and insert the formula.
=SUM(C5:C11)The syntax calculates the range of C5:C11 of column C.
- Press ENTER to get the output.
Read More: How to Sum Range of Cells in Row Using Excel VBA (6 Easy Methods)
Method 5 – Calculate the Sum of an Entire Column
Steps:
- Go to cell F5 and enter the formula.
=SUM(C:C)C:C represents the C column, and the SUM function calculates the arithmetic sum.
- Press ENTER to get the output.
Method 6 – Convert Data into Table
Steps:
- Select the entire range of the dataset.
- Go over the Insert tab >> choose Table from the Tables group.
The Create Table dialog window will open.
- Check the My table has headers box and click OK.
- Go to the Table Design tab and check the Total Row box.
You will get the total for the “Sales” column.
Read More: How to Sum Rows in Excel (9 Easy Methods)
Similar Readings
- How to Sum Colored Cells in Excel Without VBA (7 Ways)
- Sum If a Cell Contains Text in Excel (6 Suitable Formulas)
- How to Use VLOOKUP with SUM Function in Excel (6 Methods)
- Sum Formula Shortcuts in Excel (3 Quick Ways)
- How to Sum If Cell Contains Specific Text in Excel (6 Ways)
Method 7 – Sum a Column with Blank Cells
Steps:
- Go to cell C12 and enter the formula.
=SUMIFS(C5:C11,B5:B11,"")This function checks the values in the sum_range of C5:C11 and tries to match criteria criteria1 which is ” “ (blank cells) from the criteria_range i.e. B5:B11 cells.
You will get the result after pressing ENTER.
Method 8 – Sum a Column Based on Another Column
- Go to cell C12 and enter the following formula.
=SUMIF(B5:B11,"John",C5:C11)This syntax checks “John” in the criteria_range of B5:B11 and then takes the value from the sum_range and returns the sum.
Read More: How to Sum Filtered Cells in Excel (5 Suitable Ways)
Method 9 – Find the Sum of a Column with Single Criteria
Steps:
- In cell C12, enter the following formula.
=SUMIF(C5:C11,">1500",C5:C11)The function takes the sum_range i.e. C5:C11 and searches for the criteria of >1500 in the criteria_range of C5:C11.
Method 10 – Calculate Sum with Multiple Criteria
Steps:
- In cell C12, enter the following formula.
=SUMIFS(C5:C11,C5:C11,">1000",C5:C11,"<1500")The SUMIFS function takes the sum_range of C5:C11 and the criteria_range of C5:C11 for criteria1 (>1000) and criteria2 (<1500) and it will evaluate the sum.
How to Sum Multiple Columns in Excel
Steps:
- In cell E12, enter the following
=SUM(C5:E11)It will calculate the sum of three columns (C, D, and E).
- Press ENTER to get the output.
Read More: Excel Sum If a Cell Contains Criteria (5 Examples)
Further Readings
- How to Sum Cells with Text and Numbers in Excel (2 Easy Ways)
- Excel Sum Last 5 Values in Row (Formula + VBA Code)
- How to Sum Multiple Rows and Columns in Excel
- Sum to End of a Column in Excel (8 Handy Methods)
- How to Sum Colored Cells in Excel (4 Ways)
- Sum Cells in Excel: Continuous, Random, With Criteria, etc.
I tried some of these and they don’t work.
Hello George Copenhaver,
Thanks for letting us know. Some methods may work differently depending on your Excel version or the way your data is arranged. Could you please tell us which methods you tried and what happened?
If possible, share your Excel version as well. We’ll be happy to help you troubleshoot the issue.
Regards,
ExcelDemy