Each type drawing has templates, each with its own set of shapes that are ready to use. Just drag the shapes onto the drawing page and connect them to make professional-looking diagrams. When you finish, you can save your drawing in many different fo
If you want to share some of your notes, but don't want to give someone full access to all of them, you can export notes as an Adobe PDF (portable document format). For example, you might want to share a handout with a colleague who doesn't have OneN
If you want to become full, let yourself be empty. Lao Tzu
Idea Transcript
This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use.
Learn more
Sign in
Apps Install Account Training Admin
SUM function Applies To: Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, More...
The SUM function, one of the math and trig functions, adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) =SUM(A2:A10, C2:C10)
This video is part of a training course called Add numbers in Excel 2013.
Learn about adding formulas and functions Build your knowledge of formulas and functions with LinkedIn Learning. Learn how to use the SUM function to add all the numbers in a range of cells. Watch free preview >
Syntax: Quick Sum with the Status Bar Using the AutoSum Wizard Using SUM with non-contiguous cells How to add, subtract, multiply and divide with Excel Best Practices with SUM Using SUM with other functions Using SUM across multiple worksheets Common Problems Frequently Asked Questions
Need more help? You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.
See also See a video on how to use the SUM Function The SUMIF function adds only the values that meet a single criteria The SUMIFS function adds only the values that meet multiple criteria The COUNTIF function counts only the values that meet a single criteria The COUNTIFS function counts only the values that meet multiple criteria Overview of formulas in Excel How to avoid broken formulas Find and correct errors in formulas Keyboard shortcuts in Excel for Windows Keyboard shortcuts in Excel for Mac Math & Trig functions Excel functions (alphabetical) Excel functions (by Category) Adding formulas and functions (free preview)
Expand your skills E X P LORE TRA I NI NG
Get new features first J OI N OFFI CE I NS I DE RS