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.

[@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.

[@tasiejane3254]

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

[@SheldonM1945]

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

[@techteachersandstudents]

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

[@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.

[@1AmazedAnne]

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

[@sanjithp2255]

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

[@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.

[@ChriseanKim]

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

[@orangejulia4481]

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

[@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.

[@LivingGood101]

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

[@1985HKK]

Same here

[@_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 💗

[@hoib7499]

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

[@plus1truth]

Very clear and straightforward explanation, thank you !

[@ethan7973]

Just saved me hours of time. Godbless you.

[@charlestoneoyoo]

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

[@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.

[@pradhyumansharma6783]

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

[@isabellaferralotto7666]

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

[@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.

[@comrukiye]

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

[@joshliu2410]

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

[@skylerholmes3584]

Thanks for refreshing my memory! 🙏

[@thesecretlifeofaloner7655]

Thank you for this simplified tutorial. Very helpful

[@KeebasLife]

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

[@garyquack19]

thank you - sumifs is a winner!

[@kittryncarryon]

Thanks so much! Saved my assignment!❤

[@flower-fj8sv]

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

[@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😓.

[@ackinomapuranga]

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

[@Dumebi7278]

This video was very helpful. Thank you very much.

[@TylerStanczak]

Super helpful. Love using this function :)

[@kathyleung6741]

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

[@marc-edwingcostume466]

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

[@meghrajvyahalikar9452]

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

[@anilbiswas7557]

Apnr content gulo khub valo

[@richardsonantoine8043]

Thank you for this tutorial! It is so helpful.

[@brawlerstargloble9081]

Thanks. Saved so much time

[@faridahaidary3724]

Thanks very helpful love the way y explain

[@lawrencekazibwe9751]

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

[@tickroane7886]

Simple and to the point. Love it!

[@devanampuero9357]

This video saved me today! Thank you thank you

[@lorata966]

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

[@yasitha4817]

Very good explanations. Thank you so much.

[@travybaby22]

exactly what i needed. thank you.

[@CypherGreen6879]

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

[@HectorTovar-v7j]

Great explanation. Thank you!

[@vishaljhaveri7565]

Nice explanation. Thank You.

[@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

[@arvinbriones4032]

thanks sir your tutorial was very clear

[@vikramraghuwanshi9455]

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

[@rameshcounder2628]

Thank you very much. It solved my problem

[@menouthis]

Well done!! Thank you for sharing!

[@Bufferytherisa]

very clear tutorial

[@andreausa123]

Thank you Sir ! It really is helpful .

[@johnpaulursua6839]

You saved me! Thank you

[@azhari7968]

YOUR AN ANGEL

[@paras_shah]

Amazing. Keep up the great work.

[@cb-nonstopmusic....1932]

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

[@SpaceEag11]

Terrific explanation!

[@demetriouhm]

Very useful!! Thank you very much!

[@jayeshsonawane7853]

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

[@howardslade267]

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

[@Junior-cy7lv]

Thanks. you made my day!

[@cogwheelLearning]

That's a very useful formula.

[@karljackson6371]

Thanks, very helpful

[@kakylong2]

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

[@jareenc6066]

you just saved my entire GPA

[@VishalButanii]

Fantastic tutorial! :)

[@rajinrashid2455]

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

[@cathappytimes]

Thank you excellent tutorial

[@sevestiansays9699]

Thanks a lot dude!! 👍

[@cgstdivision-iibareilly2982]

thanks for explanation.

[@arthursandomine5464]

Awesome! Love excel!

[@lorenabarbosa8317]

Thanks, it was helpful!

[@adabatool6721]

Thank uuuuu super easy and understanble video

[@karlstenator]

Awesome, thanks for sharing!

[@carlobambi9035]

Gave this a like! Thanks for the informational video

[@harshithakammana7361]

Super helpful😊

[@lorimodico7960]

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

[@fataniveikune1039]

Smart, and very helpful indeed.

[@NeilMarcos-y1t]

THANKYOU!

[@orkando]

Of coarse helpful..thank you v.much

[@virajkaluarachchi4978]

Superb help 💖💖💖

[@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

[@1985HKK]

Perfect video

[@ninafeizpour7853]

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

[@isayilmaz5887]

Amazing video!

[@Theboy-qfq]

Thank you ❤

[@somlith2426]

Very helpful, thanks a lot

[@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

[@gibinjins6238]

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

[@eyadha1]

Fantastic. Many thanks

[@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"