EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel How to SUM 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

How to SUM in Excel

By Madhuri ThakurMadhuri Thakur

How to SUM in excel

How to SUM in Excel (Table of Contents)

  • How to Sum in Excel
  • Examples of How to SUM in Excel

How to SUM in Excel

There are different ways to find the sum of the given numbers in excel. This can be particular cells, the range of cell values, some filtered values, etc.

Start Your Free Excel Course

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

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,898 ratings)

The easy methods to find the sum of cell values are given below.

  • Cell’s sum in a single click
  • Using AutoSum
  • By manually entering the sum function
  • Applying subtotal for filtered cells

Examples of How to SUM in Excel

  • SUM (), AutoSum are the commonly used methods to find the sum in excel. SUM () arguments can be numbers, arrays, cell references, etc. It accepts up to 255 arguments. Let us look at a few examples.
You can download this How to do Sum Excel Template here – How to do Sum Excel Template

Example #1

  • We will see how to SUM cell values in a Single Click. Below given are the names of some items purchased and their rate. We need to find the total or sum of the rates.

How to SUM in Excel - Example 1-1

  • The fast and easy method to get the sum of the given is, click on the letter of the column and check within the status bar to find the total of the selected column values.

Excel example 1-2

  • The sum of the entire column is shown in the status bar 4591.54.

Example #2

  • Suppose you want to find the sum of the particular range of cells. You can find it just by selecting the range.
  • Suppose you want to find the sum of the rate from a particular range in the same data. Select the range of cells as below.

SUM OF RATE

  • Select the range from the second item to the 7th; once you check the status bar again, you can see the sum of that particular selected item.

rate example 2-2

Example #3

  • If you want to find the sum of cells randomly, that means not within a particular range.
  • You can select the cells you want to find the sum by pressing the Ctrl key and clicking on the cells using the mouse without releasing the Ctrl key. Here the selection is shown below.

sum of cells

  • Again check with the status bar to get the sum of selected cells. That is shown as 2028.79.

selected cells

Using AutoSUM in Excel

AutoSum is a built-in function within Excel. This will automatically calculate the sum of numbers and display them in the formula applied cell. In the previous methods, we were not able to show the sum within a cell. This will display the value as per your wish.

Example #4

  • It gave some products purchased and the bill amount. Let’s find the sum of the given products.

Excel Example 4-1

  • To avoid the range selection, select the immediate cell below the amount to find the sum.
  • Go to the Home menu, then click on AutoSum, as shown below.

Excel Example 4-2

  • The range will be automatically selected and added to the ‘=SUM’ function. If you want to change the range can select the range by picking the cells.

Excel Example 4-3

  • After the selection, press Enter Key on your keyboard. And the total will be displayed in the same cell.

Excel Example 4-4

Manually Entering the SUM Function

Another method is to use the ‘=Sum’ function manually. Apply the function and select the range of cells.

Example #5

  • Different fruits and their quantities are given below. Find the SUM of quantities.

Excel Example 5-1

  • To get the SUM of the given Qty. Select the cell below the given Quantity and apply the formula ‘=Sum ().’

Excel Example 5-2

  • This function will add the numbers to a range of cells. Within the function, specify the range of cells for which you want to get the SUM.

Excel Example 5-3

  • After selecting the cell range, press Enter on the keyboard to get the result.

Excel Example 5-4

  • The SUM of the given Quantity is 461.

Find SUM by Applying Subtotal for Filtered Cells

When you need to find the sum for a filtered cell, that means from a long list, you want to get the SUM of filtered items.

  • Below given is the list of items purchased on Different Dates and their Quantity.

 Apply subtotal for filtered cells

  • We want to find the Total quantity of Fruits. First, we need to filter the column items to get the Quantity of the Fruits. Click on any cell, then Go to the Data tab, then Click on Filter Icon.

example 6-2

  • Once you click on the Filter icon, you can see an arrow key appear near each column header.

example 6-3

  • Click on the arrow near the Items header. Uncheck the Select All’ and check the values which you want to Filter. Here we will Filter Fruits. And you will get the columns as below.

excel 6-5

  • Click on the empty cell under column Quantity. Select AutoSum from Home. The function ‘SUBTOTAL’ will appear, and the cell range will be shown as the entire column.

SUBTOTAL Example 6-6

  • Press Enter on the keyboard, and you can see only the filtered cells summed up.

SUBTOTAL example 6-7

Things to Remember about How to SUM in Excel

  • While using the formula, instead of selecting the cell range, you can manually type the cell range. This will help a large number of cells.
  • If you want to get a particular item’s sum filter from a large number of cells, then the AutoSum method is preferred.
  • A ‘#VALUE’ error will produce when trying to find the sum of text with a length of more than 255 characters.
  • Alt + = is the keyboard shortcut for AutoSum.

Recommended Articles

This has been a guide to How to SUM in Excel. Here we discussed examples of SUM in Excel and practical examples and a downloadable excel template. You can also go through our other suggested articles to learn more –

  1. SUM Cells in Excel
  2. SUMIF Formula in Excel
  3. How to Sum Multiple Rows in Excel
  4. Excel SUMIF with OR
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
1 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, 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 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 How to do Sum Excel Template

EDUCBA

Download How to do Sum Excel Template

EDUCBA

डाउनलोड How to do Sum 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