HDTutorial
EN
How to Use Sum in Excel Tutorial

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Use Sum in Excel Tutorial

419,714 views December 26, 2019 7:53

Watch on YouTube
ChannelKevin Stratvert

Description from the creator

Learn how to use the SUM function in Microsoft Excel to add values. See how you can add individual values, cell references or ranges or a mix of all three. Also learn how to use SUMIF to sum the values in a range that meet criteria that you specify.

=SUM(A2:A10) Adds the values in cells A2:10.

=SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.

You can practice with the sheet I used here: 1drv.ms/x/s!AmxrofZZlZ-whIZiN9DnXggMoFKwcA?e=Ye…

Watch more Excel tutorial videos: youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqo…
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com

As full disclosure, I work at Microsoft as a full-time employee.

About this tutorial

Kevin Stratvert published this 7:53 video tutorial on December 26, 2019. It has been watched 419,714 times on YouTube.

Duration
7:53
Published
December 26, 2019
Views
419,714
Likes
3,849

Share

Further reading

  • SUM formulas in Excel - Easy Excel Tutorial excel-easy.com

    Note: you can also use the SUM function in Excel to sum an entire row. For example, =SUM(5:5) sums all values in the 5th row. Sum Non-contiguous Cells. You can also use the SUM function in Excel to sum non-contiguous ce…

  • How to use the SUMIF function - Easy Excel Formulas excel-easy.com

    The powerful SUMIF function in Excel sums cells based on one criteria. This page contains many easy to follow SUMIF examples. Numeric Criteria. Use the SUMIF function in Excel to sum cells based on numbers that meet spe…

  • 3 Ways to Use the Sum Function in Microsoft Excel - wikiHow wikihow.com

    Article Summary X. The easiest way to find the sum of a column or row of numbers is to use Excel’s AutoSum feature. Start by clicking the first empty cell below your data if summing a column, or the first empty cell nex…

This tutorial in other languages