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: https://1drv.ms/x/s!AmxrofZZlZwhIZiN...

Watch more Excel tutorial videos:    • ❎ How to use Excel  
Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com

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