zakruti.com » IT - Software » IT, programs, coding

How to Use Sum in Excel Kevin Stratvert

video description

Rating: 4.0; Vote: 1

How to Use Sum in Excel Kevin Stratvert 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
Date: 2022-03-15

← How to Make a Table of Contents in Word - Kevin Stratvert

Concatenate Excel Kevin Stratvert →

Related videos

How to Extend Windows 10 Support For Free (Enroll Now)

• Geeks Tutorial

Private DIY Servers Are Illegal Black Markets of Piracy - The ESA's Shady Ties

• Gamers Nexus

Computing History: Exploring The TI-99/4A

• PC World

Adding Linux GPU Benchmarks: Best Distributions for Gaming Tests, ft. Wendell of Level1 Techs

• Gamers Nexus

NEW Photoshop Feature: Auto-Rename Messy Layers!

• PiXimperfect

Nano Banana vs Photoshop: A Fair Comparison

• PiXimperfect

Comments and reviews: 6

Soumia
What's the formula for totalling up Yearly shopping. Can I use autosum to total up a shopping list for the whole year?. For example can I type =SUM(D6:Z38 in Total box and click enter. And for monthly total do I use autosum by typing =SUM(D6:D38 in the total box
and click enter?.
reply

Linda
Someone once told me that you can display which cells are included by clicking on the cell with the total and then pressing a function key. I can't remember what it was. Can you remind me?
reply

Kevin
Quick trick to sum a column in Excel. Place your mouse at the bottom of the list and then press Alt and =. Excel will then automatically sum the cells above.
reply

Sathyanarayanan
Thanks a lot. Please explain date wise debit and credit total in two columns and balance in next line, just like in tally cash book.
reply

Ruby
hi Kevin, i liked your video tutorials
may i ask if you have for SUMIF and SUMIFS? i can't seem to find in your lists =)
thank you po
reply

Anthony
Liked the video Kevin, I would like to see a video on the ABS function. This is something I can-t get to grips with. Thank you
reply

Add a review, comment