15 Expert SUMIFS Function Examples in Excel - Simple to Advanced

15 Expert SUMIFS Function Examples in Excel - Simple to Advanced - Workbook Included

Рет қаралды 171,159

Күн бұрын

MY FULL EXCEL VBA COURSE [35% Discount]: www.teachexcel.com/vba-course...
200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
Excel Courses: www.teachexcel.com/premium-co...
Excel tutorial for the SUMIFS function - this includes 15 different examples that show you everything from very simple number and text matching SUMs to complex SUMs with multiple conditions, comparison operators, and wildcards.
Microsoft Docs for SUMIFS: support.microsoft.com/en-us/o...
Excel File: www.teachexcel.com/excel-tuto...
Excel Forum: www.teachexcel.com/talk/micro...
This includes the * ? ~ wildcards and how to use them in the function as well as the not-equals-to comparison operator and how to put them all together to make a powerful multi-condition function.
If you have any questions, leave them in the comment section below or visit the forum at TeachExcel.com

Пікірлер: 100

@TeachExcel 2 жыл бұрын

MY FULL EXCEL VBA COURSE (Beginner to Expert) [35% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_bHtMkarXZYQ 200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

@baktashjami 5 жыл бұрын

The clearest tutoring I have ever seen. I really enjoyed. I had something to do and was wondering how to resolve it. After watching this video, I learned it by heart and took some great notes. Thanks a lot.

@bukolaowokade3102 5 жыл бұрын

This video is well appreciated. It just solved a problem. Thank you

@alexrosen8762 6 жыл бұрын

Extremely useful tutorial. Many thanks!

@byDsign 6 жыл бұрын

Loving this Quick n' Dirty lesson format... with examples... and spreadsheet for practice! ♥ *BIG THUMBS UP!*

@TeachExcel 6 жыл бұрын

Glad you like it! :) I'm gong to start doing more of this type of tutorial and in a few hours the new one will be up for 15 IF statement examples.

@lynxwomancat 6 жыл бұрын

Great tutorial! Thanks so much! I learn something new everyday. Thank you for sharing your knowledge.

@TeachExcel 6 жыл бұрын

You're very welcome! I'm glad you liked it :)

@ramk1969 3 жыл бұрын

Most Excellent and complete "SUMIFS" tutorial on You tube...............thank you sir...........

@leonora5 2 жыл бұрын

Thanks so much! Now I understand. You explain really well.

@badran47 5 жыл бұрын

Thank you very much from Egypt. It really help me

@joe21lester 4 жыл бұрын

Awesome!!! One of the best video on this topic. Thank you very very much Sir.

@mk318020 Жыл бұрын

That was a very good tutorial. thanks!

@lukmanaliyuyahaya Жыл бұрын

Thanks alot, Man. This is very informative. I hope to apply it to something in the future

@chandrashekarchannaveerapp6391 Жыл бұрын

Hurray! finally I got, what I wanted :) Thank you very much

@wesleysapone431 4 жыл бұрын

wow, you might have just saved my interview!

@empirecity61 2 жыл бұрын

Excellent teaching style of building concept upon concept. Thank you.

@tigerkash1 5 жыл бұрын

Very useful video to understand the various situations wherein the SUMIFS formula can be used. Super useful! Thanks :-)

@TeachExcel 5 жыл бұрын

Glad you like it :)

@hrishikeshnerlekar9652 3 жыл бұрын

explained thoroughly.. thanks buddy

@paulinetran1504 Жыл бұрын

Thank you! Very easy to understand

@haneefrashid5765 2 жыл бұрын

Thanks for this great tutorial! It was exactly what I needed for a project I was working on. You've saved me a lot of time! I was wondering if there was a way to sum between certain values? So if column F had the values that you wanted to sum and column G had values 1-10 based on certain criteria would it be possible to sum all the values in F between each occurrence of the number 1 in column G? So the sum of all the values when G is 2-10 until there is another 1 in column G and the sum starts again. Thanks

@ryansinclair1678 3 жыл бұрын

You're an absolute beast. * is a game changer. Thank you, sir.

@TeachExcel 3 жыл бұрын

What an awesome comment! Thank you so much :))))

@nickiewelsh3768 4 жыл бұрын

This was HUGELY helpful!!! One quick question - is there a way to set criteria up in another column so that you don't need to recreate the formula for every different option? Does that make sense?

@MT4LYF 5 жыл бұрын

Hi What if i needed to know how many sizes between size 2 & 5 ? can it work that out from the same reference cell for the 2nd argument appreciate your help Tom

@lenbenito7273 2 жыл бұрын

Well explained. Thank you.

@GeorgeAJululian 3 жыл бұрын

Thank you it was very Helpful

@RA-rh5lb 11 ай бұрын

Thank you so much for this informative video on sumifs.. my question is can we use piovt table as an alternative for sumifs to narrow down the last example you showed..?

@smorisch 5 жыл бұрын

Thanks for this.

@stopdrinkingleftskoolaid6510 3 жыл бұрын

I always confused when to use and where to put the quotation marks. Now I know if it’s just a number no marks are needed. Wow! I wish I saw this a few years ago

@sghayadar Жыл бұрын

Awesome. Thank You.

@chhuanga7737 4 жыл бұрын

A very big thanks from mizoram

@m2ytech43 Жыл бұрын

Great!!! Is it possible to sum for those column dosent contain a partial text

@TravellerRabbit 4 жыл бұрын

Thank you for video.

@mujahidwagle3748 2 жыл бұрын

Thanks Sir many things to learn

@growth2509 3 жыл бұрын

Very good piece of information

@dbcooper488 4 жыл бұрын

Good stuff....

@annguyenkhac859 2 жыл бұрын

thanks bro !!

@neranjankarunaratne1690 6 жыл бұрын

Good One. Thanks!!

@TeachExcel 6 жыл бұрын

Glad to help :)

@muhammadimranbukhari938 5 жыл бұрын

Very good, I got it useful.

@TeachExcel 5 жыл бұрын

@31_Aditya.t 2 жыл бұрын

very helpful

@nazmidaud2665 5 жыл бұрын

Thank you

@veeruveera8400 4 жыл бұрын

Thanks sir...

@fayg9748 5 жыл бұрын

I rarely comment but this was a great tutorial!!!

@TeachExcel 5 жыл бұрын

Thank You! :)

@ElsaAndAnnie 3 жыл бұрын

Excellent

@syed599 4 жыл бұрын

Easy to understand and apply to real life works.

@TeachExcel 3 жыл бұрын

I'm really glad you think so :)

@tommyharris5817 2 жыл бұрын

How do you sum the quantity of the sizes excluding sizes 1 & 2?

@azmf80 3 жыл бұрын

Best regards really you save my day

@TeachExcel 3 жыл бұрын

Thank you! I'm really glad to hear it :)

@DaddyBearZ 6 ай бұрын

Any such formula that would add the numbers only in column D, ignoring any letters?

@persistentproductions1672 4 жыл бұрын

I am trying to create a function that after a specific number (150) it will add 10 for every 50 units above 150. but I can't seem to get SUMIFs to do this. any advice on what function I could use to accomplish this?

@sohailahmed8608 6 жыл бұрын

why this tutorial doesn't have million views. It is Sooo0000OOOOOOOOoooooperrrr Awersome..

@TeachExcel 6 жыл бұрын

Thank you so much! You can always help us by sharing the videos with friends and workmates :)

@ZiadKharrat 3 жыл бұрын

what if i want to exclude 2 criterias of 2 different ranges if they come together! for example, i want to sum the qty, excluding only the ones where [part] "-C-" 's versions are green!! so exclude all green "-C-", other "-C-" are in, other greens are in too. only "-C-" green is excluded... is there a function for it?

@POPDG00 2 жыл бұрын

How would I do it if I wanted to find the sum of the G column but anything 6 or greater counts at as a 5 since its less than 6.

@DonFohey 2 ай бұрын

I am putting together a time sheet that I want to hard code breaks and lunch. Jobs that are being tracked can take 15 minutes up to days to completion. So, I would like to call out times for breaks (8:30 am to 8:45 am, 2:30 pm to 2:45 pm) then lunch (11:15 to 12:00pm). How can this be created. Thanks,

@ashwinihabbu4456 4 жыл бұрын

Excellent video. Almost resolved all of my problems. Could I request for another scenario please? Add Qty for all that are green or red?

@tommyharris5817 2 жыл бұрын

Use the count(sum) function

@jamesgamblejr3397 9 ай бұрын

I have a VERY specific SUM(SUMIFS) question. If I have a 2 criteria SUM(SUMIF) I'd like to do with TWO array criteria, how can I correctly enter this?

@Steave-M 5 жыл бұрын

amazing keep going

@TeachExcel 5 жыл бұрын

Thank for the support!

@diinaarigaryare3065 5 жыл бұрын

Great video

@TeachExcel 5 жыл бұрын

Thanks)

@indrayanivalinjkar5737 4 жыл бұрын

how do I count sum if between size 2 to 5

@youssefdos1587 3 жыл бұрын

How excel know that the number in quantity column is the quantity and added it?

@alializadeh8195 2 жыл бұрын

Thanx

@jagankyt 3 жыл бұрын

wooooooowwwww!!!!!

@badmatt4227 Жыл бұрын

What if I do not want to put the letter - B - in the =SIMIFS formula. But instead want to reference a cell. We well say I want to refence cell C12. So, in the formula I use “*C12*” and this is not working. How can I reference a cell, where I can enter partial information and get results?

@jasirmanakkamburath9685 Жыл бұрын

Sir, SUMIF not working when referencing a cell with a formula, any solution?

@stevenls9781 4 жыл бұрын

Awesome stuff, but what if Green was a cell reference. Say the word green was in A10 and you wanted to sum everything that was not equal to green. =sumifs(G2:G9,E2:E9"A10") and any variant I can see doesn't work. Is it possible to exclude a reference from the sumifs?

@COURSSTATSCHAMBERY 3 жыл бұрын

""&A10

@samargade3416 4 жыл бұрын

I Want to remove amount Qty and Size of green and blue. How remove please help for the same

@TeachExcel 4 жыл бұрын

Not specific - if you have a specific question and can upload a sample file, head over to our forum and ask there: www.teachexcel.com/talk/microsoft-office?src=yt

@splitball 2 жыл бұрын

Sir how about a "minus" excel formula?

@kanmaniram785 5 жыл бұрын

Confused to be clear upload

@mosheslonim3255 6 жыл бұрын

Can you sumif by cell color backgroun d critrria

@TeachExcel 6 жыл бұрын

Not directly without a custom function. You can add a helper column to do this though. I'll put a tutorial for this on TeachExcel and put the link here for you.

@mosheslonim3255 6 жыл бұрын

Thank you Don

@TeachExcel 6 жыл бұрын

Here you go! I hope it helps :) (I'll also make a video for it at some point but I'm not sure when.) www.teachexcel.com/excel-tutorial/2035/do-something-based-on-cell-background-color-sumifs-if-countif-etc?nav=yt

@mosheslonim3255 6 жыл бұрын

Many thanks Don

@mahmoudaljmmal3707 6 жыл бұрын

can you explain wild character

@TeachExcel 6 жыл бұрын

Those are mentioned toward the end of the video. Basically, these characters let you match the beginning or ending part of a cell instead of having to match all of its contents; this is the simplest way to explain it. We also have a tutorial on teach excel that explains it in more detail: www.teachexcel.com/excel-tutorial/1896/wildcards-in-excel?src-yt

@KC_47. 4 жыл бұрын

Sir, can u help me with my problem.. I have a table data which contains Column A (DATE in DD/MM/YYYY), Column B (working shift which is AM, PM, ON), Column C (working area code which is A, B, C, D)..Column D (worker's name) but Column D is not included in this formula.. Lastly, F3 cell which is to search a specific date (in DD/MM/YYYY format) My formula is, =COUNTIFS(A3:A100,"="&F3,B3:B100,{"AM","PM","ON"},C3:C100,{"A","B","C","D"}) So, the problem is, the formula didn't count my desire multiple criteria correctly..it just count for the date I search, for AM shift ONLY for working area in A B C..I need the formula to count the date I search for AM PM ON shift for working area in A B C D.. Help me, sir..

@TeachExcel 4 жыл бұрын

Ask in our forum please, comments are not a great place for this. www.teachexcel.com/talk/microsoft-office?src=yt_comment

@mevartzon1374 3 жыл бұрын

How to use SUMIFS from one sheet to another sheet

@sullychow4123 Жыл бұрын

You didn't have an example of when a cell reference is the criteria itself

@raymondhunt1939 2 жыл бұрын

Excellent, Thanks!

@__-pl3jg 4 жыл бұрын

Unfortunately this tutorial doesnt mention how to account for multiple criteria from a single column. For example I can tell Excel to create a sum total of money from all lines that contain the value "Paypal". =SUMIFS(B3:B100, D3:D100, "Paypal") But excel wont allow me to add multiple criteria from the same criteria range. Example: I want to create a sum total of all payments designated as coming from Paypal, Zelle, Cash app, ect. The seemingly obvious formula should look like this....But doesnt work. Anybody have a suggestion of what Im doing wrong? =SUMIFS(B3:B100, D3:D100, "Paypal",D3:D100,"Zelle",D3:D100,"Cash app")