The Excel SUMIFS Function

Learn how to use the SUMIFS function in Excel. This useful function enables you to add up specific cells based on criteria that you specify. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... See my entire playlist of Excel videos: bit.ly/tech4excel Here is the practice file that goes with this video: bit.ly/excelSUMIFS To get the practice file, copy the link and paste it into your browser search bar. Doing so should make it download to your computer's downloads folder. #excel #exceltutorial #advancedexcel

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

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

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

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

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

[@mrCetus]

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

[@geenalawrence8338]

Thanks a bunch. Saved me a lot of trouble.

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

[@charlestoneoyoo]

Thanks so much--best Excel channel. Always learning much from 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!!!!

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

[@isabellaferralotto7666]

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

[@plus1truth]

Very clear and straightforward explanation, thank you !

[@LivingGood101]

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

[@1985HKK]

Same here

[@flower-fj8sv]

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

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

[@comrukiye]

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

[@thesecretlifeofaloner7655]

Thank you for this simplified tutorial. Very helpful

[@jadelatorre5930]

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

[@ackinomapuranga]

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

[@skylerholmes3584]

Thanks for refreshing my memory! 🙏

[@Dumebi7278]

This video was very helpful. Thank you very much.

[@kittryncarryon]

Thanks so much! Saved my assignment!❤

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

[@marc-edwingcostume466]

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

[@yasitha4817]

Very good explanations. Thank you so much.

[@hoib7499]

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

[@orangejulia4481]

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

[@meghrajvyahalikar9452]

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

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

[@HectorTovar-v7j]

Great explanation. Thank you!

[@KeebasLife]

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

[@garyquack19]

thank you - sumifs is a winner!

[@devanampuero9357]

This video saved me today! Thank you thank you

[@joshliu2410]

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

[@kathyleung6741]

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

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

[@arvinbriones4032]

thanks sir your tutorial was very clear

[@vishaljhaveri7565]

Nice explanation. Thank You.

[@richardsonantoine8043]

Thank you for this tutorial! It is so helpful.

[@andreausa123]

Thank you Sir ! It really is helpful .

[@tickroane7886]

Simple and to the point. Love it!

[@anilbiswas7557]

Apnr content gulo khub valo

[@rameshcounder2628]

Thank you very much. It solved my problem

[@lorata966]

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

[@menouthis]

Well done!! Thank you for sharing!

[@Bufferytherisa]

very clear tutorial

[@CypherGreen6879]

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

[@TylerStanczak]

Super helpful. Love using this function :)

[@johnpaulursua6839]

You saved me! Thank you

[@Junior-cy7lv]

Thanks. you made my day!

[@travybaby22]

exactly what i needed. thank you.

[@karljackson6371]

Thanks, very helpful

[@cgstdivision-iibareilly2982]

thanks for explanation.

[@cathappytimes]

Thank you excellent tutorial

[@SheldonM1945]

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

[@techteachersandstudents]

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

[@demetriouhm]

Very useful!! Thank you very much!

[@paras_shah]

Amazing. Keep up the great work.

[@vikramraghuwanshi9455]

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

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

[@SpaceEag11]

Terrific explanation!

[@lorenabarbosa8317]

Thanks, it was helpful!

[@adabatool6721]

Thank uuuuu super easy and understanble video

[@서지희-y4x]

Thank you so much 🙏

[@azhari7968]

YOUR AN ANGEL

[@VishalButanii]

Fantastic tutorial! :)

[@karlstenator]

Awesome, thanks for sharing!

[@moshtradamus92]

Thank you!

[@kakylong2]

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

[@orkando]

Of coarse helpful..thank you v.much

[@cb-nonstopmusic....1932]

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

[@ictshare1]

Thank so much. your sharing.

[@cogwheelLearning]

That's a very useful formula.

[@1985HKK]

Perfect video

[@eyadha1]

Fantastic. Many thanks

[@jayeshsonawane7853]

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

[@sevestiansays9699]

Thanks a lot dude!! 👍

[@carlobambi9035]

Gave this a like! Thanks for the informational video

[@arthursandomine5464]

Awesome! Love excel!

[@isayilmaz5887]

Amazing video!

[@somlith2426]

Very helpful, thanks a lot

[@aleksandarmarre7878]

Super Helpfull!

[@sunilchavan484]

very helpful

[@GambitMasterDuel]

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

[@Theboy-qfq]

Thank you ❤

[@fataniveikune1039]

Smart, and very helpful indeed.

[@ubaidillahmuhammad20]

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

[@amnahalholi1471]

Thank You

[@raghavwasan7562]

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

[@harshithakammana7361]

Super helpful😊

[@rajinrashid2455]

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

[@Malik-ix2kx]

Great Video….

[@howardslade267]

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