In this lesson, I’m going to be showing you how to:
- Understand what is the SUM function
- How to insert the SUM function
- Entering text and numbers in Excel
Download the Excel file below, and save it onto your computer. So you can complete this lesson with me.
Go ahead, open the video below and watch the tutorial at your own pace:
If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)
Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂
Watch this tutorial directly on our YouTube channel and Subscribe
Thanks for watching!
Do you want to learn to create your own website?
If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.
CLICK HERE to read our review about this amazing learning platform, if you want to know more.
When you’re ready move onto:
Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive
Or go back to:
Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)
Hope you are enjoying your learning 🙂
Habib Ali – ICT Tutor

As usual a well-presented tutorial on the functions of excel. Albeit it’s a very basic function to carry out, there are many various ways of performing this function which you covered exceptionally well. Perhaps this is the first lesson I did not learn something new because it is such a basic and widely used function. I still enjoy watching just to make sure I didn’t miss anything and if at all else as a refresher. Thanks again Habib your tutorials are awesome to learn from.
Most definitely agree with you. The sum function is the most commonly used.
Many more lessons are coming. So keep an eye out for those. 🙂
Wishing you all the best
Habib (ICT Tutor)
This is one of the most essential functions of all. The SUM function is easy, but I somehow make mistakes and get it wrong. Nice tutorial.
Thanks.
That’s great to know. I would suggest you keeping playing the videos until you are confident with them.
All the best
Habib (ICT Tutor)
I absolutely loved this tutorial on SUM Function in Excel. Everything was so clear and concise. Thanks for sharing!
You are welcome Aminah.
All the best
Habib (ICT Tutor)
Great lesson on the SUM function in Excel!
You have explained how to use this particular function in various ways and have done so in such a way that makes it very easy and clear for us to understand. Thank you for that.
Also, thank you for all of the time, effort, and work that you put in to deliver these valuable and informative lessons to us. It is very much appreciated.
Thank you Michael and you’re very welcome. I appreciate your feedback and comment. Take care 🙂
Habib (ICT tutor)
I love using excel. I have used it for as long as it has existed. I still struggle with it every day. The lessons I have read so far, have already solved two issues. Thank you and I have signed up for the lessons, This is great!
Excellent Rob, happy to hear you have resolved 2 issues so far. Once you have completed the full 62 lessons I have on Excel on my website and YouTube channel, so far, then you will have learnt many new skills and probably solve many more issues you face when using Excel.
I recommend you subscribe to my YouTube channel to get alerts for all new lessons. I have big plans for many lessons on the full suite of Microsoft Office 365. All the best 🙂
Habib (ICT tutor)
A really good, precise, step by step tutorial for anyone who wants to learn more about Excel. I do use Excel a lot, but I just remembered It wasn’t so easy to learn it when I just started. I find your way of braking it up and explaining every little detail way much better than the book I used to read than, back in many years. You make it very clear, very understandable and very followable (hmm, is that a word or I just made it up?)
Anyway, keep up the excellent work, I’m sure I’ll be back to see how it goes on!
Thank you for your feedback Kerryanne. I have and will always make all my lessons of great quality and easy to understand. Don’t forget I have a YouTube channel, where you can subscribe for all future lessons too.
Habib (ICT tutor)
I love the Sum function, and the video explains everything we could need to know about it.
Your tutorials are great!
Thank you for your feedback.
All the best
Habib (ICT Tutor)
Many thanks for sharing your knowledge in a way that is so easy to understand. Iv’e tried to learn before from lessons on youtube, but because of my lack of understand about excel, I often didn’t know how to ask the right questions to find out how to do what I was trying to achieve.
I think I had better go through your lessons one by one, and put the information into practice so that I will remember it.
Many thanks,
Andrew
Hi Andrew,
I’m glad to hear you have come across my lessons on YouTube at last, that are beneficial for you! Yes definitely, watch the videos and then practice them to reinforce the learning.
All the best.
Habib (ICT Tutor)
Hi Habib,
The tutorial about the formula_SUM is super clear that everyone could understand it easily without confusion. I love that you also attached the exact excel file you demonstrated in the video here, so we can practice it after finishing watching this video. I can see that you put lots of effort and time for excel training, and it does provide me value and help.
Cheers,
Matt
Thanks Matt. I want all my visitors to benefit to the maximum, hence my lessons are very clear and they include the working file, like you said so everyone can practice after watching the video.
I wholeheartedly believe – if you give value to the best possible, then you will automatically receive the value back in may different ways.
Take care 🙂
Habib (ICT tutor)
Another great tutorial, where would I be without you and all videos.
Thank you again. Very helpful.
Thank you very much for your feedback. It’s appreciated. Glad to hear my lessons are helpful for you.
Habib (ICT Tutorial)
Hi Habib,
The sum function is one of the important functions of excel. I really learned new ideas.
I saved your website so it will be a reference for me whenever I need a solution for any query. moreover, the lessons are labeled so I can find easily what I want.
I expect great success for this site
Have a great day
Rania
Hello Rania,
Many thanks for liking my Excel tutorial and making a good use of them. I want the whole world to get access to a good and legit education. Hence, created these tutorials.
Thank you for your best wishes. I’m truly humbled.
Habib
Hi Ali,
This is very informative we already know this only because we are going to school right now and we are learning this and you have shredded more light on the subject.
Thank you for teaching us more than we know. We are glad to see the video is helpful as well showing you what is needed to know and how to do it.
This is going to be a very beneficial site to others that have no idea what excel can do for them and Microsoft 360. This program has helped us out so much for the right projects.
Cheers,
Mathew&Deloris
You’re very welcome Mathew and Deloris 🙂
Habib (ICT tutor)
Hi Habib,
This lesson was very easy to follow and understand! You’re saving me a lot of time in Excel teaching me these skills 🙂
Hi Christine,
I’m glad to hear it. I’m uploading many more lessons regularly on my YouTube channel. So, please check it out.
Best wishes
Habib (ICT Tutor)
Hi Habib,
Thanks so much for this post. You just saved me so many hours of struggling with deleting a row from an excel product list.
This is so far the best place of understanding using excel.
V/r
Thank you very much for the very kind words, and I’m happy to hear you think our site is the best for excel learning. Benson, we also have an YouTube channel, that you might like to check out 🙂
Habib (ICT tutor)
Hi Habib
Great work. This is second time in this exercise, you make it easy for me to understand.
Thanks
That’s great feedback Peter! Thank you! 🙂
Hi again Habib, Thank you for these two lessons. This was my first time using spreadsheets, Formulas and functions. I have completed both and have learnt a lot.
You are going through the lessons very fast. Keep on learning and repeat the videos as many times as you need to. Great work. SUM function is used for adding only, please remember that. Well done
Habib (ICT Tutor)
Hi Habib,
Another great video! I appreciate you walking us through how to complete a sum function in Excel. Keep up the good work.
Warm regards,
Sonia
Hi Sonia,
Thank you for your comments and feedback and that you found these tutorials on Exel useful.
All the best
Habib (ICT tutor)
I’m following the whole course – a great step by step approach!
That’s great. There are many more useful contents on our YouTube cahnnel at https://www.youtube.com/channel/UCBfGJLMmTIA3ESh9DFYWLIg
Best Regards
Habib (ICT tutor)
Very clearly explained.
Thank you Pharaha – I hope you have understood the SUM function clearly.
Habib (ICT Tutor)
This is a great tutorial. Very helpful. Thank you, Habib.
Thank you Samantha – happy to hear you have benefitted from this tutorial.
Habib (ICT Tutor)
Very simple, concisely done and slow paced which will suit all audiences. Good job.
Thanks Imran for your positive feedback.
Kind regards
Habib
You explained this lesson really well. Thank you Habib
Hi Alison,
Many thanks for visiting our site at https://lifestyletipsandhacks.com/ and sharing your views. There are more contents like these are on their way soon. So, keep a look out for that.
Thank you
Habib
Hi Habib,
Thanks for this video – Excel is a key business tool but there are a lot of nuances to trip people up. Understanding the differences between functions and formulas is such a key element of using data tools effectively.
Have you considered showing differences between Excel and Google sheets?
Thanks!
Lisa
Hi Lisa,
Thanks for your lovely feedback. I just wanted to create a demonstration to excel as user friendly as possible. I will be making many more videos in the upcoming days. So please keep an eye out on that.
Kind Regards
Habib
This a truly special motivational post. Thank you so much for this help.
Thanks nati for your lovely feedback. There are many more contents like these are on their way soon at https://lifestyletipsandhacks.com/
Kind regards
Habib
Hey,
Really understood the video and I like how you have put your website together.
Keep going with your articles and videos and keep inspiring us.
All the best,
Tom
Thanks Tom for this encouraging feedback.
Plesse visit our website at
https://lifestyletipsandhacks.com/ for more contents.
Best wishes
Habib
Any special motivated post will always be successful, such as this one. Please carry on making these tutorial videos, they are very beneficial.
Thanks nati. I shall I take your advice on board!
Kind regards
Habib
Very straightforward video to help young students like myself with their work.
Very clear and you made it look so simple.
Keep up the good work!
Hey dear Ibrahim,
You’ve made my day with your feedback. It’s very encouraging.
Thank you
Habib
In this video Habib explains how to replicate the formula, when to use SUM function and what is difference between formula and function. Excellent explanation!
Thanks for your lovely explanations about this video Irina. I appreciate all your support and kind words.
Kindest regards
Habib
Excellent tutorial and explained well. Thank you
Thanks for your lovely comment Justine.
Kind regards
Habib
Hi Habib. This is a great tutorial for anyone struggling to understand all these technical features of excel. If I ever struggle again I will watch this again. Thank you
Hi Chantelle, Yes, I have made all my tutorials very easy for anyone to understand. Feel free to start my lessons from lesson 1, and keep on learning.
Habib (ICT Tutor)