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!AmxrofZZlZ-whIZiN9DnXggMoFKwcA?e=Ye4Tdd
Watch more Excel tutorial videos: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
– Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com
As full disclosure, I work at Microsoft as a full-time employee.
