The Excel SUMIFS Function

[@wicked-words]

I have to add to all the praise here - I am also creating a budget and have been getting my brain tangled up in knots watching Excel videos... you are the first person to actually make this easy and accessible. THANK YOU!!

[@Dexter101x]

Excel has gotten a lot more powerful over the years, but thanks to videos like this, it's a lot easier

[@Matrix6704]

This is so great. I love that you use a large set of data. It is more realistic and better to follow to me.

[@SheldonM1945]

Geat job !! easy to follow. I am now a subscriber.

[@techteachersandstudents]

Awesome, thank you! Thanks so much for your kind gift.

[@eliphs11]

Thank you for this and your other tutorial videos! Using what I learn to create a dynamic budget tracker and your videos have proven to be indispensable.

[@divyar2567]

I saw many vedio i didnt understood at all these formula really u r explanation is grate and understandable thank you so much Sir

[@thatzintun4477]

Before I watch this video, I was struggling with sumifs function. However after I watch it, it was so clear explanation. I really like this video.

[@sanjithp2255]

i like how you explain small tips and tricks along the way.

[@1AmazedAnne]

💃💃💃... me celebrating after learning how to use SUMIFS successfully by following this example. Much appreciated.

[@HarpreetSingh1991]

This is the first viideo I watched to learn SUMIFS formula and I understood very well. Thanks for your video and I have subscribed.

[@tasiejane3254]

You’re a lifesaver ❤
I have been trying to get this sumif for a while now
Thank you so much ❤❤

[@_P.K.]

You have excelled in the explanation. Saw just once and I was able to get it. Thank you!

[@salmasabry9599]

Your accent is clear 👌 and you help me with this tutorial so much 💗

[@erinwilkins6365]

Thank you thank you for this video! I could not find out what was wrong with my formula and watching this video once fixed it.

[@rothschildianum]

Great video!!!! Short and easy to understand! I hate those videos that talk too much. We do not care who you are... .Just teach us the formulas.

[@LivingGood101]

This was the perfect video for exactly what I was looking for, thank you.

[@1985HKK]

Same here

[@ChriseanKim]

Thanks for your clear and not complicate teaching, this video helps me a lot.

[@TylerStanczak]

Super helpful. Love using this function :)

[@orangejulia4481]

These are the best Excel videos I've found on TH-cam. Easy to follow and understand. Thank you!

[@ethan7973]

Just saved me hours of time. Godbless you.

[@pradhyumansharma6783]

THANKYOU YOU MADE MY LIFEEASY.HELPED ME TO COMPLETE MY PROJECT THANKS A LOTTT!!!!

[@charlestoneoyoo]

Thanks so much--best Excel channel. Always learning much from you!

[@isabellaferralotto7666]

Thank you so much 😍😍 I can’t explain how helpful these videos are!!!

[@comrukiye]

Thank you so much I struggled with understanding this, this video made me understand the formula!

[@plus1truth]

Very clear and straightforward explanation, thank you !

[@jadelatorre5930]

Subscribed! Now I really understand what sumifs is. I will be able to finish my tasks early bc of this. Thank you!

[@geenalawrence8338]

Thanks a bunch. Saved me a lot of trouble.

[@skylerholmes3584]

Thanks for refreshing my memory! 🙏

[@hoib7499]

Thank you! I love the simplicity of the way you teach.

[@honeysvbooks]

Thank you so much. Your videos are all very easy to understand compared to other yt videos.

[@techteachersandstudents]

Glad to hear that!

[@honeysvbooks]

@@techteachersandstudents Do you have videos on how to extract data from a single cell? I'm doing something where you need to separate the data from a single cell into 3 columns (Date, Description and Amount). And it says every column has different formulas. I cant find any videos, and I have no idea what that formula is😓.

[@kittryncarryon]

Thanks so much! Saved my assignment!❤

[@joshliu2410]

Wow! How interesting is learning Excel with you. You're the best. Bless you!

[@ackinomapuranga]

Thank you very very much for this tutorial, it has helped me a lot, in just a second.

[@KeebasLife]

These are great refreshers for me. Clear instructions very easy to follow...Thank you

[@Dumebi7278]

This video was very helpful. Thank you very much.

[@thesecretlifeofaloner7655]

Thank you for this simplified tutorial. Very helpful

[@flower-fj8sv]

THANK YOU! So useful oh my goodness, this is amazing.

[@kawtarcherkaoui727]

Thank you sooo much, it was very useful!

[@marc-edwingcostume466]

Thanks for the video it helps me understand a file that I was working on

[@richardsonantoine8043]

Thank you for this tutorial! It is so helpful.

[@HectorTovar-v7j]

Great explanation. Thank you!

[@kathyleung6741]

Got it!!! Your explanation is very clear and you give some example to support your data!! Well done you!! :)

[@garyquack19]

thank you - sumifs is a winner!

[@yasitha4817]

Very good explanations. Thank you so much.

[@faridahaidary3724]

Thanks very helpful love the way y explain

[@brawlerstargloble9081]

Thanks. Saved so much time

[@meghrajvyahalikar9452]

thank you very much...it is very helpful to me

[@devanampuero9357]

This video saved me today! Thank you thank you

[@anilbiswas7557]

Apnr content gulo khub valo

[@menouthis]

Well done!! Thank you for sharing!

[@tickroane7886]

Simple and to the point. Love it!

[@vishaljhaveri7565]

Nice explanation. Thank You.

[@travybaby22]

exactly what i needed. thank you.

[@paras_shah]

Amazing. Keep up the great work.

[@CypherGreen6879]

Great tutorial! I'm making my way through your videos.

[@lorata966]

Thanks for your great explanation, now I can play with this powerful formula.

[@lawrencekazibwe9751]

Thanks alot boss, have been suffering by adding them separately,ie consuming alot of time

[@andreausa123]

Thank you Sir ! It really is helpful .

[@kakylong2]

Love, love, love your videos. I've learned so much & realize how little I know. 😆 Great job! Keep them coming! 😊

[@arvinbriones4032]

thanks sir your tutorial was very clear

[@VishalButanii]

Fantastic tutorial! :)

[@jpettys]

Great explanation. I noticed your range references are based on something like Table1[column] instead of, eg, D2:D25. Do you have a video that explains how that is set up?

[@geneyan]

Select the range, and turn them into a table by clicking on "Format as Table". The next time you select the range, it will appear as you described.

[@jjessica7582]

Cntl + T

[@carlobambi9035]

Gave this a like! Thanks for the informational video

[@vikramraghuwanshi9455]

Very well explained'., Hats off to you.But how do we got practise of that .?

[@cb-nonstopmusic....1932]

Good Job Man easy explanation 1 more subscriber way to go champ!!!!!

[@johnpaulursua6839]

You saved me! Thank you

[@demetriouhm]

Very useful!! Thank you very much!

[@rameshcounder2628]

Thank you very much. It solved my problem

[@sevestiansays9699]

Thanks a lot dude!! 👍

[@gibinjins6238]

How to sum a number for example greater than 10, if the criteria range and the sum range are the same

[@cathappytimes]

Thank you excellent tutorial

[@Junior-cy7lv]

Thanks. you made my day!

[@ubaidillahmuhammad20]

Nice job. Put an excel file in the description ...

[@SpaceEag11]

Terrific explanation!

[@jayeshsonawane7853]

hello and thanks ..this was really helpful
but i had a doubt how you will print the sumifs() value in another sheet

[@lorenabarbosa8317]

Thanks, it was helpful!

[@karljackson6371]

Thanks, very helpful

[@JL-kw7qc]

Can I substitute subtotal for sumifs?

[@karlstenator]

Awesome, thanks for sharing!

[@GambitMasterDuel]

Cool bro, thank you for sharing this video, it is really helpful

[@rushawnbeecher4069]

Can the first and second criteria range be the same range

[@cogwheelLearning]

That's a very useful formula.

[@rajinrashid2455]

So, it's basically a handy form of the AND function in excel for summing?

[@phubjamtsho6638]

could you please show me how to find all genre cost paid sum of DVD. especially when there is more than two criteria range and criteria. thank you

[@howardslade267]

I am trying to make an Automatic Bowling Scoresheet. Any suggestions for the formula here?

[@Bufferytherisa]

very clear tutorial

[@pusthvpa]

Please will you explain about PPT presentation

[@cgstdivision-iibareilly2982]

thanks for explanation.

[@miroych]

I just subscribed. Could you please review the link you posted to download the Excel file for us to practice with? That link does not work to download the file, but to take us to the tutorial video instead. I have tried those links to download other files and they don''t work either, they take us to the same video tutorial, not to download the actual file to practice. Thanks!!

[@techteachersandstudents]

Thanks for reaching out about this. I'm not sure why that's happening, but it's happening for me too. Maybe TH-cam changed the way links work in their descriptions. I'm not sure. However, if you copy the link and paste it into your browser search bar, doing so should make it download to your computer's downloads folder. It's working for me at least. Please try that. Thanks!

[@adabatool6721]

Thank uuuuu super easy and understanble video

[@ninafeizpour7853]

how did you make those title cells with the drop menu ex. "formula, genre" ?

[@sushobhande2270]

hello, great video, can you share this excel sheet for us to practice? thanx in advance .

[@jareenc6066]

you just saved my entire GPA

[@peacemaker6460]

Can you use 2 selections from the same criteria range? e.g. if you want the cost of mystery and horror in the same sum, cheers.

[@lorimodico7960]

I see mystery in three cells, which would add to more than the amount you posted.

[@RA-rh5lb]

This could be easily done through pviot table then why should go for sumif? could you please assist and clear my doubts. Thanks in advance

[@somlith2426]

Very helpful, thanks a lot

[@Noahwxlr]

What if my 3rd criterion is a single selection from a drop down list instead of another full range of data like "Genre"? How would this formula be created? Would it still be a SUMIFS function or something else?
P.S. I am trying to figure this out for a real application. I am trying to sum values of different trading accounts by account type. I am not able to list a single cell with the account type in quotes. For example... "Trading" or "Roth IRA"

[@ictshare1]

Thank so much. your sharing.

[@raghavwasan7562]

thanks. How would we frame this if we wanted to sum any format of >$5? Where would we include that in the formula?

[@elinat6993]

=SUMIFS(E2:E10;E2:E10;">5")