Lesson 58 – SUMIFS function in Excel to ADD multiple CRITERIONS from different columns

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

  1. Use the SUMIFS function to ADD up the revenue by using criterions from multiple columns or categories

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 59: FORMULATEXT function in Excel | Display formulas or functions of individual cells only

Or go back to:

Lesson 57: SUMIF function used to ADD up MULTIPLE different items in one column in Excel | SUMIF+SUMIF

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

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, Date, Percentages and apply Decimal Places to numbers in Excel

Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit

Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells

Lesson 10: How to use the INSERT FUNCTION command in Excel

Lesson 9: Simple Subtraction Formula in Excel

Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel

Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

Lesson 5: Average Function in Excel | What does Average mean

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons

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

40 thoughts on “Lesson 58 – SUMIFS function in Excel to ADD multiple CRITERIONS from different columns”

  1. This is awesome, you’ve become my go to place for excel answers now when I’m stuck.
    Only thing I wish is that there was a better way to search for my excel question. I tried using your search bar to look for some answers but no results came up, I had to go back to using Google to search.

    Besides that, great site!

    • Hi Lee, the search bar is very effective on my site. However, if you search for something and I don’t have a lesson on it yet, then you won’t get any results. Can I ask, what have you searched for, and got no results? Thank you for the comment and compliment.

      Habib (ICT tutor)

  2. During my year of travel I didn’t invest any money, because I didn’t know if I would have an internet connection to keep an eye on them. But now that I have settled I am back to investing. The formulas you explain come in handy for my spreadsheets in which I keep an extra eye on these investments.
    Maybe there are programs to do that, but it’s not that I have tons to spend, so a spreadsheet will do.
    Especially if I can work with the formulas.
    Thanks Habib, you’re making my life a bit easier. 😀

  3. The SUMIFS function in Excel is a feature that I had not heard of before today’s lesson. Adding multiple criterions from different columns would have seemed like such a daunting task, but after watching this lesson, you have simplified the entire process for me.

    Thank you for another very informative lesson.

    • You’re very welcome Michael. Yes, Excel makes our lives so much easier, as it does all the daunting tasks for us. Take care 🙂

      Habib (ICT tutor)

    • Hi Musa,

      Thank you very much for your feedback that my video tutorials are helpful for you. You can share the videos with your family and friends, so they can benefit from them too.

      All the best

      Habib (ICT Tutor)

  4. Thank you so much for this lesson on SUMIFS function in Excel. It’s really useful for me and with your explanations I’m sure I’ll have no problems. Really appreciate it.
    Thanks a lot.

    • Hi,

      Many thanks for your lovely feedback. Please keep visiting our website and YouTube channel for more upcoming videos.

      Best Regards

      Habib (ICT Tutor)

  5. Using the SUMIFS function for me is a bit more advenced in excel but after your lesson I find it very easy and explained really well and detailed. Thank you.

    • This is really helpful feedback from you in preparing upcoming Excel video tutorials. Please keep visiting our site and YouTube channel and let us know if you would like anything else to be covered in future videos.

      Best wishes

      Habib (ICT Tutor)

  6. I did not know this was possible. It almost helps you use excel to create a database. Thank you for demonstrating how to do it so well.

    Using functions has seemed complicated to me in the past. You do such a great job of walking newbies like me through the process. I didn’t know that when you used functions, that excel would walk you through the process as you fill in the needed information.


    • Hi Greg,

      Thank you very much.

      All my lessons are very easy to understand and follow because I always focus on breaking down the complex aspects and putting into simple language.

      Habib (ICT Tutor)

    • Thanks for your feedback Alyse.

      We have more exciting video planned. So please keep visiting our site for that. Also, you can share them with your family, friends and colleagues so they can benefit from these lessons too.

      Best wishes

      Habib (ICt Tutor)

  7. Hello Habib, thank you for your another informative training! I always gained benefits and learnt a lot while watching your tutorial. For me SUMIFS in excel and to add multiple criterions from different columns is difficult then others you created. Would you consider to create some trainings, like how to create chart table in excel, or something easy functions?

    • Thank you for your feedback.

      SUMIFS is not the easiest therefore I would recommend you watching the videos a few times and I guarantee you will understand it.

      I will be doing lessons of chart tables which to be honest is not very difficult. But I will add them to my to do list.

      I have many lessons on my YouTube channel which cover the basic formulas and functions as well as the more advanced.

      Habib (ICT Tutor)

  8. Hello Habib, I always gained benefits and learnt a lot after reading your trainings. Always found that your trainings are useful and informative! SUMIFS function in Excel to ADD multiple CRITERIONS this function for me is new and difficult. Would you consider to create some easy trainings? Like how to create a chart table on Excel, or something like that?

    • I recommend you watch the video lesson a few times and am sure you will find it much easier. However, I have created many other lessons covering the more basic formulas and functions in Excel. Start from lesson 1 and complete all the lessons for a comprehensive learning. Take care Ling 🙂

      Habib (ICT tutor)

  9. Hi Habib
    SUMIFS function is very difficult to make but with the help of your explanation, I can make it very easily. Your site and channel are a great reference for excel. I wish you great success in your business

    • Hi Rania,

      Many Thanks for your compliments and feedback. It’s very much appreciated. Please keep visiting our website and YouTube channel for many more upcoming contents.

      Best wishes

      Habib (ICt Tutor)

  10. I’ve only just came across your site and believe this will benefit my highly in my current work. Being a sales and project manager, I deal with sums of money, products and projects on a daily bases. Working out monthly figures are always a struggle so I hope I can apply some of your training.
    Thanks for the great video and I’ll make sure to watch more!


    • Absolutely Damon! The SUMIFS function is the perfect for you to use in your sales and project managerial roles.

      Also, feel free to watch the rest of my video lessons, starting from lesson 1.

      Best Regards

      Habib (ICT Tutor)

  11. That is one function I never knew about. The function sumifs is so much more powerful and I can see where it would replace a lot of other functions to do the same thing. I use to sum each column with the sumif function and then add them all together. Now I know how a better way thanks to your very helpful lesson Habib. Looking forward to your next lesson.

    • Hi Rick,

      Thank you for your feedback, and you are right about everything you said about the SUMIFS function. In simple terms, the SUMIFS function is a better version of the SUMIF function.

      Habib (ICT Tutor)

  12. Hi there,

    What an insightful article and video, you strike gold again! Thanks for sharing this. I didn’t even realise such a rule exist! This is definitely a winning formula for people who want to learn Excel rules! Additionally, it’s very useful as a refresher, I learned many rules but didn’t use them and forgot how to do them.

    • Thank you for your comment. The SUMIFS function is definitely one to use when adding up multiple criterions. It is always good to refresh your skills, therefore I do recommend you starting from lesson 1.

      All the best

      Habib (ICT Tutor)

  13. Hey Habib, i am very happy that i stumbled on your website. I am very passionate about data analysis and though i use the previous sum of function in excel, it always a good thing to learn about new strategies.
    Thank you for the walkthrough video, its very insightful.

  14. Thanks a lot for sharing this lesson on sumifs function in excel. I appreciate the entire guide you’ve created here. I hope other will find this as useful as I did. Thanks!

    • Hi Ivan,

      Thank you for your feedback. Glad to hear my video lessons are useful for you. Please do share them with your family and friends, so they can benefit too.

      Best Regards

      Habib (ICT Tutor)

  15. This excel’s function is very useful, besides the video is very easy to understand, great lessons! , keep that way!

    best wishes!


    • Dear Sonia,

      Many thanks for letting me know how useful my video lessons on Excel are. Please keep visiting our YouTube channel and website for more useful content. Also, let me know if their is anything else you would like to learn in Excel.

      Best Regards

      Habib (ICT Tutor)

  16. Wow, this is lesson 58 already? I have learned so much by following your tutorials. This SUMIFS function is great to calculate several criteria, and I am going to practice with the excel sheet you provided. I downloaded it, and I am going to do a few exercises myself to practice a little 😉
    Could I, for example, calculate how many retailers reside within my zip code and how high their profits are now during covid, if they are over a certain percentage level?

    • Thank you Christine for your feedback. Yes, of course you can. However, you will need to add more criterions within the SUMIFS function. Give us a shout if you need any further help. Take care 🙂

      Habib (ICT tutor)

  17. Years ago, I took a course in computer programs, including excell, but if you don’t use the functions, you forget the knowledge. I love that you have such a nicely transparent list of different functions on your site that a person can come back at any time and see or watch video of what they are specifically interested in.
    Great work!


Leave a comment

Share via
Copy link
Powered by Social Snap