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

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

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

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

[@salmasabry9599]

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

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

[@1AmazedAnne]

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

[@tasiejane3254]

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

[@sanjithp2255]

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

[@_P.K.]

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

[@ChriseanKim]

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

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

[@orangejulia4481]

These are the best Excel videos I've found on RUclips. Easy to follow and understand. 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!

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

[@isabellaferralotto7666]

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

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

[@ethan7973]

Just saved me hours of time. Godbless you.

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

[@kathyleung6741]

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

[@LivingGood101]

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

[@1985HKK]

Same here

[@lawrencekazibwe9751]

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

[@hoib7499]

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

[@ackinomapuranga]

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

[@thesecretlifeofaloner7655]

Thank you for this simplified tutorial. Very helpful

[@joshliu2410]

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

[@Dumebi7278]

This video was very helpful. Thank you very much.

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

[@KeebasLife]

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

[@kittryncarryon]

Thanks so much! Saved my assignment!❤

[@marc-edwingcostume466]

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

[@flower-fj8sv]

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

[@skylerholmes3584]

Thanks for refreshing my memory! 🙏

[@yasitha4817]

Very good explanations. Thank you so much.

[@geenalawrence8338]

Thanks a bunch. Saved me a lot of trouble.

[@hikerbikeromar]

Perfect tutorial, thank you!

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

[@richardsonantoine8043]

Thank you for this tutorial! It is so helpful.

[@TylerStanczak]

Super helpful. Love using this function :)

[@kawtarcherkaoui727]

Thank you sooo much, it was very useful!

[@garyquack19]

thank you - sumifs is a winner!

[@devanampuero9357]

This video saved me today! Thank you thank you

[@HectorTovar-v7j]

Great explanation. Thank you!

[@lorata966]

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

[@anilbiswas7557]

Apnr content gulo khub valo

[@meghrajvyahalikar9452]

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

[@CypherGreen6879]

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

[@tickroane7886]

Simple and to the point. Love it!

[@faridahaidary3724]

Thanks very helpful love the way y explain

[@brawlerstargloble9081]

Thanks. Saved so much time

[@cb-nonstopmusic....1932]

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

[@vishaljhaveri7565]

Nice explanation. Thank You.

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

[@menouthis]

Well done!! Thank you for sharing!

[@carlobambi9035]

Gave this a like! Thanks for the informational video

[@paras_shah]

Amazing. Keep up the great work.

[@jayeshsonawane7853]

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

[@rameshcounder2628]

Thank you very much. It solved my problem

[@jacobsphamandlayoko2008]

Lovely video. Thank you

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

[@rajinrashid2455]

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

[@ubaidillahmuhammad20]

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

[@demetriouhm]

Very useful!! Thank you very much!

[@travybaby22]

exactly what i needed. thank you.

[@rushawnbeecher4069]

Can the first and second criteria range be the same range

[@GambitMasterDuel]

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

[@johnpaulursua6839]

You saved me! Thank you

[@SpaceEag11]

Terrific explanation!

[@howardslade267]

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

[@lorimodico7960]

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

[@cathappytimes]

Thank you excellent tutorial

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

[@VishalButanii]

Fantastic tutorial! :)

[@Bufferytherisa]

very clear tutorial

[@Junior-cy7lv]

Thanks. you made my day!

[@lorenabarbosa8317]

Thanks, it was helpful!

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

[@adabatool6721]

Thank uuuuu super easy and understanble video

[@karljackson6371]

Thanks, very helpful

[@karlstenator]

Awesome, thanks for sharing!

[@pusthvpa]

Please will you explain about PPT presentation

[@cgstdivision-iibareilly2982]

thanks for explanation.

[@sevestiansays9699]

Thanks a lot dude!! 👍

[@sushobhande2270]

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

[@JL-kw7qc]

Can I substitute subtotal for sumifs?

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

[@ninafeizpour7853]

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

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

[@cogwheelLearning]

That's a very useful formula.

[@somlith2426]

Very helpful, thanks a lot

[@orkando]

Of coarse helpful..thank you v.much

[@stevefrench8512]

Great video. Do you have a video that totals up 2 ranges and highlights if they don't match ?

[@maxmillman9477]

apply conditional formatting to range you want highlighted: select range > condition > specify highlighting desired e.g. "red background" > based on a formula > =A1B1