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
@ramk19693 жыл бұрын
Most Excellent and complete "SUMIFS" tutorial on You tube...............thank you sir...........
@baktashjami5 жыл бұрын
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.
@ryansinclair16783 жыл бұрын
You're an absolute beast. * is a game changer. Thank you, sir.
@TeachExcel3 жыл бұрын
What an awesome comment! Thank you so much :))))
@lynxwomancat6 жыл бұрын
Great tutorial! Thanks so much! I learn something new everyday. Thank you for sharing your knowledge.
@TeachExcel6 жыл бұрын
You're very welcome! I'm glad you liked it :)
@tigerkash16 жыл бұрын
Very useful video to understand the various situations wherein the SUMIFS formula can be used. Super useful! Thanks :-)
@TeachExcel6 жыл бұрын
Glad you like it :)
@stopdrinkingleftskoolaid65103 жыл бұрын
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
@leonora53 жыл бұрын
Thanks so much! Now I understand. You explain really well.
@bukolaowokade31026 жыл бұрын
This video is well appreciated. It just solved a problem. Thank you
@empirecity612 жыл бұрын
Excellent teaching style of building concept upon concept. Thank you.
@mk3180202 жыл бұрын
That was a very good tutorial. thanks!
@byDsign6 жыл бұрын
Loving this Quick n' Dirty lesson format... with examples... and spreadsheet for practice! ♥ *BIG THUMBS UP!*
@TeachExcel6 жыл бұрын
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.
@ashwinihabbu44564 жыл бұрын
Excellent video. Almost resolved all of my problems. Could I request for another scenario please? Add Qty for all that are green or red?
@tommyharris58172 жыл бұрын
Use the count(sum) function
@wesleysapone4314 жыл бұрын
wow, you might have just saved my interview!
@chandrashekarchannaveerapp63912 жыл бұрын
Hurray! finally I got, what I wanted :) Thank you very much
@badran475 жыл бұрын
Thank you very much from Egypt. It really help me
@lukmanaliyuyahaya Жыл бұрын
Thanks alot, Man. This is very informative. I hope to apply it to something in the future
@azmf803 жыл бұрын
Best regards really you save my day
@TeachExcel3 жыл бұрын
Thank you! I'm really glad to hear it :)
@syed5994 жыл бұрын
Easy to understand and apply to real life works.
@TeachExcel3 жыл бұрын
I'm really glad you think so :)
@joe21lester4 жыл бұрын
Awesome!!! One of the best video on this topic. Thank you very very much Sir.
@paulinetran1504 Жыл бұрын
Thank you! Very easy to understand
@fayg97485 жыл бұрын
I rarely comment but this was a great tutorial!!!
@TeachExcel5 жыл бұрын
Thank You! :)
@haneefrashid57652 жыл бұрын
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
@m2ytech432 жыл бұрын
Great!!! Is it possible to sum for those column dosent contain a partial text
@mujahidwagle37482 жыл бұрын
Thanks Sir many things to learn
@hrishikeshnerlekar96523 жыл бұрын
explained thoroughly.. thanks buddy
@RA-rh5lb Жыл бұрын
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..?
@nickiewelsh37685 жыл бұрын
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?
@alexrosen87626 жыл бұрын
Extremely useful tutorial. Many thanks!
@chhuanga77375 жыл бұрын
A very big thanks from mizoram
@GeorgeAJululian3 жыл бұрын
Thank you it was very Helpful
@lenbenito72732 жыл бұрын
Well explained. Thank you.
@DaddyBearZ8 ай бұрын
Any such formula that would add the numbers only in column D, ignoring any letters?
@DonFohey5 ай бұрын
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,
@growth25093 жыл бұрын
Very good piece of information
@jamesgamblejr3397 Жыл бұрын
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?
@POPDG002 жыл бұрын
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.
@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?
@ZiadKharrat3 жыл бұрын
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?
@ElsaAndAnnie3 жыл бұрын
Excellent
@MT4LYF5 жыл бұрын
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
@tommyharris58172 жыл бұрын
How do you sum the quantity of the sizes excluding sizes 1 & 2?
@persistentproductions16724 жыл бұрын
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?
@sghayadar Жыл бұрын
Awesome. Thank You.
@jasirmanakkamburath9685 Жыл бұрын
Sir, SUMIF not working when referencing a cell with a formula, any solution?
@stevenls97814 жыл бұрын
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?
@COURSSTATSCHAMBERY3 жыл бұрын
""&A10
@dbcooper4884 жыл бұрын
Good stuff....
@annguyenkhac8592 жыл бұрын
thanks bro !!
@youssefdos15874 жыл бұрын
How excel know that the number in quantity column is the quantity and added it?
@splitball3 жыл бұрын
Sir how about a "minus" excel formula?
@TravellerRabbit5 жыл бұрын
Thank you for video.
@31_Aditya.t3 жыл бұрын
very helpful
@muhammadimranbukhari9386 жыл бұрын
Very good, I got it useful.
@TeachExcel6 жыл бұрын
:)
@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..
@TeachExcel4 жыл бұрын
Ask in our forum please, comments are not a great place for this. www.teachexcel.com/talk/microsoft-office?src=yt_comment
@alializadeh81952 жыл бұрын
Thanx
@غلاممحمداحسان17 күн бұрын
hi dear how i can this formula =SUM(SUMIFS('۱'!F:F,'۱'!I:I,{"ahmad","asad"},'۱'!G:G,"1",'۱'!H:H,{"kandahar","helmand"}))
@indrayanivalinjkar57374 жыл бұрын
how do I count sum if between size 2 to 5
@neranjankarunaratne16906 жыл бұрын
Good One. Thanks!!
@TeachExcel6 жыл бұрын
Glad to help :)
@nazmidaud26655 жыл бұрын
Thank you
@veeruveera84005 жыл бұрын
Thanks sir...
@samargade34165 жыл бұрын
I Want to remove amount Qty and Size of green and blue. How remove please help for the same
@TeachExcel5 жыл бұрын
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
@__-pl3jg4 жыл бұрын
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")
@diinaarigaryare30655 жыл бұрын
Great video
@TeachExcel5 жыл бұрын
Thanks)
@mevartzon13744 жыл бұрын
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
@Steave-M6 жыл бұрын
amazing keep going
@TeachExcel6 жыл бұрын
Thank for the support!
@kanmaniram7855 жыл бұрын
Confused to be clear upload
@mahmoudaljmmal37076 жыл бұрын
can you explain wild character
@TeachExcel6 жыл бұрын
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
@shivanshmishra795820 күн бұрын
5:17 13:00
@mosheslonim32556 жыл бұрын
Can you sumif by cell color backgroun d critrria
@TeachExcel6 жыл бұрын
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.
@mosheslonim32556 жыл бұрын
Thank you Don
@TeachExcel6 жыл бұрын
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
@mosheslonim32556 жыл бұрын
Many thanks Don
@LasDivine2 жыл бұрын
Wait why is the first one a 7?
@stools44375 жыл бұрын
What about the criteria is a certain symbol?
@jagankyt4 жыл бұрын
wooooooowwwww!!!!!
@samia42702 жыл бұрын
1
@KennieMarshall2 жыл бұрын
You didn’t do blanks. This would have been perfect. :(
@fridayvan-defoe69874 жыл бұрын
"asterix" not "asterisk".. Great tutorial though:)
@GetKnowledgeByYasir5 жыл бұрын
o
@غلاممحمداحسان17 күн бұрын
or this =SUM(SUMIFS('۱'!E:E,'۱'!I:I,{"1403/1/1","1403/1/2","1403/1/3","1403/1/4","1403/1/5","1403/1/6","1403/1/7","1403/1/8","1403/1/9","1403/1/10","1403/1/11","1403/1/12","1403/1/13","1403/1/14","1403/1/15","1403/1/16","1403/1/17","1403/1/18","1403/1/19","1403/1/20","1403/1/21","1403/1/22","1403/1/23","1403/1/24","1403/1/25","1403/1/26","1403/1/27","1403/1/28","1403/1/29","1403/1/30","1403/1/31"},'۱'!H:H,{"تجارتی","رهایشی "})) thanks