Excel - The SUM function Tutorial
In this video, you will learn about the SUM function in Microsoft 365. The video demonstrates how to use the SUM function to add up a range of cells in Excel.
It explains the syntax of the SUM function and shows how to add adjacent cells, non-adjacent cells, and cells from different worksheets.
This knowledge will help you efficiently calculate sums in Excel and improve your data analysis skills.
- 4:37
- 4983 views
-
Remove a watermark
- 2:20
- Viewed 39976 times
-
Change the default font for your emails
- 1:09
- Viewed 23593 times
-
Collapsible headings
- 3:03
- Viewed 20294 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 20257 times
-
Activate the features of Teams Premium
- 3:48
- Viewed 19709 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 16964 times
-
Create automatic reminders
- 4:10
- Viewed 13135 times
-
Protect a document shared by password
- 1:41
- Viewed 12057 times
-
Morph transition
- 0:43
- Viewed 11230 times
-
Add a sound effect to a transition
- 3:45
- Viewed 10732 times
-
Remove a watermark
- 2:20
- Viewed 39976 times
-
Change the default font for your emails
- 1:09
- Viewed 23593 times
-
Collapsible headings
- 3:03
- Viewed 20294 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 20257 times
-
Activate the features of Teams Premium
- 3:48
- Viewed 19709 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 16964 times
-
Create automatic reminders
- 4:10
- Viewed 13135 times
-
Protect a document shared by password
- 1:41
- Viewed 12057 times
-
Morph transition
- 0:43
- Viewed 11230 times
-
Add a sound effect to a transition
- 3:45
- Viewed 10732 times
-
Block the transfer of a Teams meeting
- 02:40
- Viewed 20 times
-
Control the start of recording and transcription in Teams
- 03:03
- Viewed 21 times
-
Manage access to recordings and transcripts in Teams
- 02:59
- Viewed 19 times
-
Enable voice isolation in Teams
- 02:14
- Viewed 32 times
-
Add a collaborative page to a Teams channel
- 03:06
- Viewed 18 times
-
Manage a channel’s files with the Shared tab in Teams
- 03:34
- Viewed 29 times
-
Track conversations and organize channels in Teams
- 03:26
- Viewed 20 times
-
Create a team and set up the first channel in Teams
- 03:02
- Viewed 21 times
-
Create a newsletter in Outlook
- 02:23
- Viewed 56 times
-
Create an issue in an Outlook newsletter
- 03:27
- Viewed 60 times
Objectifs :
Understand how to use the SUM function in Excel to perform calculations on ranges of cells, including adjacent and non-adjacent cells, and across different worksheets.
Chapitres :
-
Introduction to the SUM Function
The SUM function in Excel is a powerful tool that allows users to add together a range of numbers quickly. This section introduces the concept of functions as predefined formulas that simplify calculations. -
Understanding the SUM Formula
When you click inside a cell with an AutoSum value, you will see a formula that utilizes the SUM function. The basic syntax of the SUM function is as follows: - **SUM( number1, number2, ... )** Here, 'number1' is a required argument, while subsequent numbers are optional and can be enclosed in square brackets. Arguments are separated by commas and can include numbers, cell references, or results from other functions. -
Creating a SUM Formula
To create a SUM formula, follow these steps: 1. Type `SUM(`. 2. Select the range of cells you want to add. 3. Close the parenthesis and press Enter. For example, to sum the range from B2 to B5, you would enter `SUM(B2:B5)`, which adds the values in cells B2, B3, B4, and B5. -
Using AutoSum
The AutoSum feature automatically selects adjacent cells for summation. However, to sum an entire column or non-adjacent cells, you can manually enter the SUM function. For instance, to add non-adjacent cells, hold down the Ctrl key while selecting the desired ranges. -
Summing Across Worksheets
Excel allows you to sum numbers from different worksheets within the same workbook. To do this, start with an equal sign followed by the SUM function. For example: - `=SUM(Sheet2!C8, Sheet3!D5)` This formula begins with an equal sign, includes the SUM function, and references cells from different worksheets using the format: `worksheet_name!cell_reference`. -
Conclusion
The SUM function is an essential tool in Excel for performing quick calculations. By understanding its syntax and how to apply it to both adjacent and non-adjacent cells, as well as across different worksheets, users can enhance their data analysis capabilities.
FAQ :
What is the AutoSum feature?
The AutoSum feature in spreadsheet software automatically calculates the sum of a selected range of cells, making it easier to perform quick calculations.
How do I use the SUM function?
To use the SUM function, type =SUM(, select the range of cells you want to add, and then close the parentheses and press Enter. For example, =SUM(B2:B5) adds the values in cells B2 through B5.
Can I sum cells from different worksheets?
Yes, you can sum cells from different worksheets in the same workbook by using the syntax =SUM('SheetName'!CellReference1, 'SheetName'!CellReference2).
What are arguments in a function?
Arguments are the values or cell references that a function uses to perform calculations. In the SUM function, these can be numbers, ranges of cells, or results from other functions.
What is the maximum number of arguments I can use in the SUM function?
You can use up to 255 arguments in the SUM function.
What is the difference between adjacent and non-adjacent cells?
Adjacent cells are next to each other, while non-adjacent cells are separated by other cells. You can select non-adjacent cells by holding down the Ctrl key while clicking on them.
Quelques cas d'usages :
Budget Calculation
In financial planning, you can use the SUM function to calculate total expenses by summing up values from different categories in a budget worksheet. This helps in tracking spending and ensuring you stay within budget.
Sales Data Analysis
Sales teams can use the SUM function to aggregate sales figures from multiple regions or products across different worksheets, allowing for comprehensive performance analysis and reporting.
Project Management
Project managers can utilize the SUM function to calculate total hours worked by team members on various tasks, helping to monitor project progress and resource allocation.
Inventory Management
In inventory management, the SUM function can be used to calculate total stock levels across different product categories, aiding in restocking decisions and inventory control.
Academic Performance Tracking
Educators can apply the SUM function to calculate total scores or grades for students by summing individual assignment scores from different worksheets, facilitating performance tracking and reporting.
Glossaire :
AutoSum
A feature in spreadsheet software that automatically calculates the sum of a range of cells.
Function
A predefined formula in spreadsheet applications that performs calculations using specific values, called arguments.
SUM function
A specific function used to add together a range of numbers or cells in a spreadsheet. The syntax is SUM(number1, number2, ...).
Arguments
Values or cell references that a function uses to perform its calculations. In the SUM function, these are the numbers or ranges you want to add.
Range of cells
A selection of two or more cells in a spreadsheet, typically defined by the starting and ending cell references (e.g., B2:B5).
Adjacent cells
Cells that are next to each other in a row or column.
Non-adjacent cells
Cells that are not next to each other and can be selected by holding down the Ctrl key while clicking on them.
Worksheet
A single page or tab within a spreadsheet file where data is organized in rows and columns.
Workbook
A file that contains one or more worksheets in spreadsheet software.