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

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

  1. Use the SUMIF function to ADD up multiple different items from the SAME range or column
  2. Add up ALL types of criteria in the same column EXCEPT one criteria
  3. Use SUMIF + SUMIF

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 58: SUMIFS function in Excel to ADD multiple CRITERIONS from different columns

Or go back to:

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

32 thoughts on “Lesson 57 – SUMIF function used to ADD up MULTIPLE different items in one column in Excel | SUMIF+SUMIF”

  1. SUMIF+SUMIF is a good lesson. Very essential, especially when doing accounting. I now realize its value, Habib. Thanks for this lesson and the tips you give along the way are invaluable.
    – AB

  2. Hello Habib.
    Thank you for this lesson on adding multiple items in one row . My son uses some of your training and explanations when he does his school projects / reports. I always tell him to go have a look at your website when he gets stuck on something.

    • Hello Felicity,

      Many thanks for recommending my Excel tutorials to your son and it’s great to know that he’s benefitting from them too.

      Wishing you all the best.

      Habib (ICT Tutor)

  3. Hi Habib,

    Thank you for sharing. I really love this tutorial. It is because it is the most advanced technique for me. I didn’t know the SUMIF function. I really didn’t know how to do it if I was asked to do the same tasks. Now, I know how to use the SUMIF function to calculate a bit complicated tasks. Thank you so much. Your video tutorials are always helpful

    All the best,


  4. Hey man
    Funny enough I learnt how to use the add function a few days ago. I was lacking a bit more on this and your tutorial was a good thing to refer to and it has been very helpful thanx again.
    Keep up the good work

    • Hi Thabo,

      I’m glad my video tutorial on Excel has been helpful for you.

      Thank you for stopping by and leaving us a comment.

      All the best

      Habib (ICt Tutor)

  5. Thank you for another great lesson! I’m beginning to feel like an excel pro now 😉 I just need to keep on practicing to get more confident, so I can use it on my own. These are useful skills to have when you are running your own business.

    • Hi Christine,

      Many thanks for your encouraging feedback. I am glad to hear my video tutorials on Excel will be helpful in running your own online business.

      Please keep visiting our site and YouTube channel for mote useful contents.

      Best wishes

      Habib (ICT Tutor)

  6. I did have algebra and math in my Dutch high school, but it is such a long time ago. As the functions of Excel are so extended and there are so many combinations possible, I sometimes feel that algebra and math didn’t prepare me for it at all. 🙂
    So thank you for explaining this in a clear manner, Habib!

    • Hi Hannie,

      Thank you for sharing your childhood learning with us. Excel learning is almost automated only if you know what you are doing. Seems like you are learning by watching my Excel video lessons. Keep up the great work. Let me know if I need to make any more advanced or basic.

      Wishing you best of luck.

      Habib (ICT Tutor)

  7. Hi Habib, I was doing my taxes for the years 2019 and I use Excel for my balance sheet and your excel lesson help me to do it the way my accounting will understand it good.

    Thank you for these good information on excel,

  8. Is this Excel 202 or already 303? 🙂
    It’s getting pretty complicated. But you make it easier to understand, so thank you so much for your effort. I keep hearing functions described by you I had no idea existed. So many possibilities! Almost endless it seems.
    Thanks, Habib.

    • Hi Hannie – I’m using Excel 365, which is the latest version of Excel, but you can apply all the knowledge from my lessons to most versions of Excel. Take care

      Habib (ICT tutor)

  9. Thanks a ton for this tutorial Habib! It really helped me solve a problem I was having with a data sheet. I’ve used Excel a lot in the past and even got formal training on it but the truth is that if you don’t use it for a while you forget many of the functions and how to form functions. It doesn’t help that I learned Excel in Finnish and mainly use it in English these days, so the functions are of course named differently. I’ll definitely bookmark your site and subscribe to your YouTube channel for future reference!

  10. Hi Habib,

    What an interesting lesson this was. Using SUMIF to add up multiple items in one column is so handy.

    I appreciate you detailing the shortcut option, as well as teaching us to ensure that the correct range is selected (something that many people may not otherwise think to do).

    Thank you for another great lesson!

  11. Another great excell training video. I always learn something new from your lessons and they are easy to follow along as well especially with the provided data sheet you share. You mentioned there are two ways to “All except Blackpool”. I though of another one and that is to add the Revenue then substract the sumif “blackpool”. Not as good as using the “blackpool”. Thanks for the lesson

    • Hi Rick – yes you can do that. But you have to try and do the entire function as one string. This way you wouldn’t have to create unnecessary formulas or functions and waste time and ultimately productivity in a work place.

      Habib (ICT tutor)

  12. When I worked with excel a few years ago I had some trouble with these formulas, but you explained it so well and made it so clear in this tutorial. I think that now I have a much better understanding of it. Thank you!

    • That’s great to know Christine that my lessons are helpful for you in learning the Excel formulas.

      Keep learning and you can also share them with your family and friends, so they can benefit from these Free Microsoft video lessons.

      Best wishes

      Habib (ICT Tutor)

  13. Loved the lesson, thanks for this. I’ve been trying to figure some other things out in Excel so I’m off to lesson 55. Can’t wait until you cover some of the financial topics.

    One question, could I use an “OR” or an “AND” inside the statement to shorten it somehow?

    • Hi Sean, thanks for the compliment. Yes, OR/AND can be used. I will try and do a lesson with these examples. So, keep an eye out for that. Take care 🙂

      Habib (ICT tutor)

  14. Hello,
    It took me a very short time to understand this function, really this lesson, like the previous ones, improves my excel day by day.
    Don’t stop generating these kind of lessons, and I’m looking forward to see the video about Pivot Tables in the future.


    • Hi Margot – I wont be stopping creating my lessons, in fact I have much bigger plans of creating hundreds of lessons, which will cover pivot tables in Excel. Also, I plan to do lessons on the full Microsoft Office suite – Word, Powerpoint, Access, Publisher etc. So bookmark our site and subscribe to our YouTube channel.

      Habib (ICT tutor)


Leave a comment

Share via
Copy link
Powered by Social Snap