EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel SUM Cells in Excel
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

SUM Cells in Excel

By Madhuri ThakurMadhuri Thakur

SUM Cells in Excel

SUM Cells in Excel (Table of Contents)

  • Introduction to SUM Cells in Excel
  • Examples of SUM Cells in Excel

Introduction to SUM Cells in Excel

When performing data operations in any context such as research, business, and academic projects etc., the sum operation is commonly used. Excel stores a number in an individual cell, and while performing the sum operation across the cells, the entire range(s) has to be taken into consideration. Excel provides various ways to sum the numeric contents in cells.

Syntax:

The syntax of the SUM function is SUM(number1, number2… number n).

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

SUM Cells Syntax

Examples of SUM Cells in Excel

Let’s go through the examples as described in the following section.

You can download this SUM Cells Excel Template here – SUM Cells Excel Template

Example #1

We have Sales data for various products for a particular time period. Their product IDs have represented the products. The dataset is as shown in the following screenshot.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,596 ratings)

SUM Cells in Excel 1-3

Now, we intend to obtain total sales. This will, essentially, be sales obtained after adding sales for all the products. So, at the bottom, we will have “Total”. Using the SUM function, we will obtain total sales. The SUM function will be implemented as shown below. Note, here; we selected all those cells that contain sales figures for respective products. We can pass individual numbers separated by commas or pass range(s) in the SUM function. Once done, complete the bracket and press Enter Key.

SUM Cells in Excel 1-2

If we pass the argument (range of cells containing numeric values) properly into the SUM function, then we get the correct result. The following screenshot shows the cells summed up using the SUM function. In the cell, we got the total sales as a number, and in the formula bar, we can see the formula that sums up the numeric contents in the mentioned range.

SUM Cells in Excel 1-5

Example #2

Here, we have marks for five different subjects for a certain number of students. Now, our task is to obtain total marks for each student. This we will do by adding the marks for five marks using the SUM function. Once implemented in the first cell, the function then will have to be copied down across all the requisite cells. The following screenshot shows the marks of data for students. In the Total columns, we want a total of five subjects for each student.

SUM Cells 2-1

We implemented the SUM function to sum cells across the range containing marks of five subjects, as shown in the following screenshot. Observe how the function has been implemented. Once the requisite range is passed as an argument, close the function and press Enter Key. If implemented correctly, we shall obtain the right results.

SUM Cells 2-2

As can be seen in the following screenshot, we obtained the total marks for each of the students using the SUM function, following the above procedure properly. Note that to verify that the right correct totals have been obtained, just select the range we had used for addition and see the sum in the status bar. If both the figures match then, we have successfully managed to sum cells to obtain total marks for each student.

SUM Cells 2-3

In this example, summing marks for each subject across different students is not meaningful, as a total of marks for all students is never desired.

Example #3

In the first example we discussed, we summed cells across rows, and in the second column, we summer cell across columns. The context governs the summing of cells, and we have seen it with examples. In this example, we will require to sum across rows as well as columns because both sums stand meaningful.

Let’s first understand the data. We have product sales data for five different years, from 2014 to 2018. The sales figures for different products for these years are given, as can be seen in the below screenshot.

Product Sales Data

Our task is to obtain total sales figures for each of the products for all the years and total sales figures for all the products. The former sum task essentially means summing across columns, while the later sum task essentially means summing across the rows. First, we will perform sum of cells across columns, i.e. total sales for each product across different years. We can obtain the sum by implementing the SUM function, as shown in the below screenshot. Observe how the function has been implemented and what range it takes into consideration. Once done, close the function and press Enter Key.

Product Sales

We obtained the total across all the years in the data, and the total figures can be seen as shown in the below screenshot.

Total Cells Value

We are just half done, and now we want to obtain total sales for each of the years. For this, we implemented the function, as can be seen in the below screenshot. Here, one fact must be noted carefully. As we can see, the Year label is also a number, so while performing sum operation for summing across cells in the range, ensure that cell with year value is not selected, or else we shall end up obtaining incorrect results. Such scenarios are prone to this common blunder when obtaining sums through shortcuts.

SUM Operation

As described in the preceding section, we implemented the SUM function and successfully obtained the results, as can be seen in the following screenshot.

SUM Cells 3-5

Once all the totals have been obtained, we should check if the results are correct. One of the ways to do this is to select the range that we intend to sum. Excel gives Average, Count, and Sum details for the selected range in the status bar. Validate the requisite figures by cross-checking. As can be seen in the following screenshot, the sum of numbers in the selected cells matches the sum figure in the status bar.

SUM Cells 3-6

Things to Remember

  • In Excel, we can sum across cells using the SUM function; however, based on the context, it must be decided if summing across rows is feasible or summing across columns.
  • Sometimes, SUM may return an error. These errors must be handled appropriately using suitable functionalities provided by Excel.

Recommended Articles

This is a guide to SUM Cells in Excel. Here we discuss How to SUM Cells in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. How to SUM in Excel
  2. Excel SUMIFS with Dates
  3. How to Sum Multiple Rows in Excel
  4. SUMIF Formula in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formulas, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download SUM Cells Excel Template

EDUCBA

Download SUM Cells Excel Template

EDUCBA

डाउनलोड SUM Cells Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more