Lesson 56 – SUMIF function in Excel | What it is & how to insert the SUMIF function in Excel?

In this lesson, I’m going to be showing you how to:

  1. Understand, what the SUMIF function is used for in Excel
  2. Insert a SUMIF function 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 anything 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 57 – SUMIF function used to ADD up MULTIPLE different items in one column in Excel | SUMIF+SUMIF

Or go back to:

Lesson 55 – COUNT function in Excel | COUNTA function in Excel | COUNTBLANK function in Excel

Lesson 54 – COUNTIFS function in Excel with 2 examples | How to use Data Filter in Excel

Lesson 53 – COUNTIF function used to COUNT MULTIPLE different items in a column in Excel | COUNTIF+COUNTIF

Lesson 52 – COUNTIF function in Excel | What it is & how to insert the COUNTIF function in Excel?

Lesson 51 – How to use FILTER DATA in Excel | Number Filters: Greater Than Or Equal To | Less Than

Lesson 50 – How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel

Lesson 49 – How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel

Lesson 48 – How to Hide & Unhide Worksheets in Excel | Hide Worksheets, so it CANNOT be unhidden easily in Excel!

Lesson 47 – How to Hide & Unhide Rows & Columns in Excel | Hide & Unhide Multiples Columns & Rows in Excel

Lesson 46 – Find & Replace in Excel | What is Match Case & Match Entire Cell Contents in Excel

Lesson 45 – How to apply borders around and in-between cells in Excel | Difference between borders & Gridlines in Excel

Lesson 44 – Use the IF function to work out if you are over BUDGET or not in Excel

Lesson 43 – How to change a DATE to different FORMATS in Excel

Lesson 42 – How to set and print rows & titles automatically at the top of each page in Excel

Lesson 41 – How to display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel

Lesson 40 – How to MOVE a chart to a new worksheet on its own in Excel | Name the new worksheet in Excel

Lesson 39 – How to insert a LINE chart with MARKERS in Excel | Select non-adjacent data in Excel

Lesson 38 – How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel

Lesson 37 – How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart in Excel

Lesson 36 – Best method to COPY a CHART to a new worksheet in Excel | Making sure data is LINKED with the new chart!

Lesson 35 – How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange and Rename worksheets in Excel

Lesson 34 – What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel

Lesson 33 – How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?

Lesson 32 – What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel

Lesson 31 – Relative OR Absolute references in Excel | Everything explained | Confusion solved!

Lesson 30 – Best method to format numbers to display as PERCENTAGES in Excel

Lesson 29 – Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel

Lesson 28 – A simple DIVISION formula in Excel | How to DIVIDE in Excel

Lesson 27 – What is the thousand separator in Excel | How to use the thousand separator in Excel

Lesson 26 – Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?

Lesson 25 – Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?

Lesson 24 – How to SORT data in ASCENDING order in Excel

Lesson 23 – Best techniques to widen columns & adjust the height of rows in Excel

Lesson 22 – How to RENAME a worksheet in Excel

Lesson 21 – How to COPY cells from one spreadsheet to another spreadsheet in Excel

Lesson 20 – How to select multiple NON-ADJACENT cells in Excel | What are the benefits?

Lesson 19 – What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?

Lesson 18 – What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?

Lesson 17 – How to PRINT the spreadsheet SHOWING the formulas and functions in Excel

Lesson 16 – What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel

Lesson 15 – Format the Font colour in Excel | Shade a range of cells to any colour in Excel

Lesson 14 – How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?

Lesson 13 – How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel?

Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?

Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?

Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?

Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?

Lesson 8 – What is the IF function, and how to insert it in Excel?

Lesson 7 – What is the ROUND function, and how to insert it in Excel?

Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?

Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?

Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?

Lesson 3 – Simple Subtraction Formula using Excel

Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

Lesson 1 – Simple multiplication Formula using Excel

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

18 thoughts on “Lesson 56 – SUMIF function in Excel | What it is & how to insert the SUMIF function in Excel?”

  1. Hello Habib, your training of SUMIF in Excel is very handy! Before I just knew SUM and COUNTIF, etc. Now I known even more! I admit that the SUMIF function is quite difficult, but after watched your tutorial, it becomes much easier! No doubts that I learnt a lot on your tutorial! I have a question, is it possible if SUMIF this function can be added from other Excel sheet in the same file?

    Reply
    • Yes Ling, you can use the SUMIF function and use ranges from another worksheet. Refer to my lesson 49 and lesson 50, which will teach you about linking worksheets and workbooks using formulas and functions. Hope this is helpful for you. Take care 🙂

      Habib (ICT tutor)

      Reply
  2. Hello Habib,

    Your lessons on how to use Excel make it so easy to understand and use very practically. You make using a function like SUMIF very easy to use for anybody ho has the interest to use it. Your instructions are very clear and concise in your delivery as always. Thank you for using your talents as a tutor.

    Regards,

    Courtney-

    Reply
    • Hi Courtney,

      I really appreciate your feedback and leaving us a comment. I try my best to keep the lessons simple and easy to follow. Glad you are benefiting from these video tutorials.

      Wishing you all the best.

      Habib (ICT Tutor)

      Reply
  3. Hi Habib:

    The SUMIF function is quite the feature in Excel. How handy and convenient!

    Speaking of which, the Insert function is even handier and more convenient still. The more I learn about Excel from you, the more I enjoy the program and can see its power and usefulness.

    Thank you.

    Reply
    • Hi Michael,

      Fantastic! Thank you for your feedback. Please visit our site and YouTube channel for more upcoming contents.

      Best Regards

      Habib (ICT Tutor)

      Reply
  4. Habib,

    Thanks for that step by step! I’m not an Excel expert but it seems like a great way to add up the revenue from a specific area. I have a question, you talked about how using the SUM function is different from the SUMIF function. Would that difference be that SUMIF you’re trying to specify a data set rather than be more general with the SUM function? Again, I don’t know if that question made sense, but I hope it does. Thank you for the video instruction!

    Reply
    • Hi Robert, yes you’re spot on. the SUM function will add the entire range, but the SUMIF will add specific cells within the range. Hope this clarifies things for you. Take care 🙂

      Habib (ICT tutor)

      Reply
  5. Hello Habib Ali,

    This lesson is very interesting, the “step by step” of this site is really very easy to understand, going straight to the “problems” that many excel users always have.
    The videos are very complete and truly, something that was difficult to understand, in 15 minutes it cleared up several doubts that I had.
    Adding these lessons to “my favorites”!

    Thank you so much !
    Richard.

    Reply
    • Hi Richard,
      It’s great to hear you are benefiting from my Excel tutorials. It’s so good news that my lessons are high quality and easier to understand for you.

      Thank you for your lovely feedback.

      Best wishes

      Habib (ICt Tutor)

      Reply
  6. Thanks for sharing so much knowledge of Excel, they are so useful for me. SUMIF function is so convenient. I will try it at work.

    Reply
    • Hi Lena,

      Thanks for your feedback. Please keep visiting our site and YouTube channel as I have many more lessons uploaded there, and I am also doing many more in the near future.

      Habib (ICT Tutor)

      Reply
  7. This was very well explained, because I find the SUMIF function a little difficult to do, but now that I watched this tutorial, it is so much clearer to me. You are a very good teacher! I am going to practice a little bit 🙂

    Reply
    • Dear Christine,

      Thank you so much for your feedback that my tutorial was useful for you. Keep practicing and also, you can share these Excel lessons with your family and friends, so they can can benefit from my FREE video tutorials on Microsoft Excel.

      All the best

      Habib (ICT Tutor)

      Reply
  8. I am so glad to have your tutoring skills at my disposal, Habib! You are truly great at what you do. There is so much about Excel that I didn’t know until I found your blog! I have to admit that some of the info here went over my head a little, but that is because I have always struggled with numbers. I actually have a math disability, and although Excel does a lot of the heavy lifting for you, I still struggle with understanding some of it.

    But that is the beauty of recording! I can go back and watch these videos again for future reference!

    Reply
    • Thank you for your kind comment Darcy. Yes, excel does most of the difficult mathematical parts for us, but you do need to have a basic understanding of math’s, it certainly helps. Also, you are right to say that you can watch my lessons over and over again till any of the mental blocks disappear. If you have any further questions, please do let me know and I will answer them for you asap. Take care 🙂

      Habib (ICT tutor)

      Reply
  9. An awesome website with awesome topic! I have seen one of your first lessons on excel and thought it was a great idea. Although I am familiar with the program itself, I found myself watching the whole video, and I liked the very simple, very understandable way you built up the lesson. I do know a lot of people who can’t or can only use it with limitations, and I’m quite sure your website will be bookmarked by many of them, as they can really benefit from your tutorials. I’ll certainly share it with many.

    Reply
    • Thank you Kerryanne for your feedback and support for sharing our website with people who you think will benefit from my excel lessons. Take care 🙂
      Habib (ICT tutor)

      Reply

Leave a comment

Share via
Copy link
Powered by Social Snap