The Excel SUMIFS Function
Вставка
- Опубліковано 23 жов 2024
- 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
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!!
Excel has gotten a lot more powerful over the years, but thanks to videos like this, it's a lot easier
This is so great. I love that you use a large set of data. It is more realistic and better to follow to me.
I saw many vedio i didnt understood at all these formula really u r explanation is grate and understandable thank you so much Sir
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.
i like how you explain small tips and tricks along the way.
💃💃💃... me celebrating after learning how to use SUMIFS successfully by following this example. Much appreciated.
You have excelled in the explanation. Saw just once and I was able to get it. Thank you!
Your accent is clear 👌 and you help me with this tutorial so much 💗
Thanks for your clear and not complicate teaching, this video helps me a lot.
Thanks a bunch. Saved me a lot of trouble.
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.
Thanks so much--best Excel channel. Always learning much from you!
Just saved me hours of time. Godbless you.
THANKYOU YOU MADE MY LIFEEASY.HELPED ME TO COMPLETE MY PROJECT THANKS A LOTTT!!!!
This is the first viideo I watched to learn SUMIFS formula and I understood very well. Thanks for your video and I have subscribed.
Thank you so much 😍😍 I can’t explain how helpful these videos are!!!
Very clear and straightforward explanation, thank you !
This was the perfect video for exactly what I was looking for, thank you.
Same here
THANK YOU! So useful oh my goodness, this is amazing.
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.
Thank you so much I struggled with understanding this, this video made me understand the formula!
Thank you for this simplified tutorial. Very helpful
Subscribed! Now I really understand what sumifs is. I will be able to finish my tasks early bc of this. Thank you!
Thank you very very much for this tutorial, it has helped me a lot, in just a second.
Thanks for refreshing my memory! 🙏
This video was very helpful. Thank you very much.
Thanks so much! Saved my assignment!❤
Thank you so much. Your videos are all very easy to understand compared to other yt videos.
Glad to hear that!
@@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😓.
Thanks for the video it helps me understand a file that I was working on
Very good explanations. Thank you so much.
Thank you! I love the simplicity of the way you teach.
These are the best Excel videos I've found on UA-cam. Easy to follow and understand. Thank you!
thank you very much...it is very helpful to me
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.
Great explanation. Thank you!
These are great refreshers for me. Clear instructions very easy to follow...Thank you
thank you - sumifs is a winner!
This video saved me today! Thank you thank you
Wow! How interesting is learning Excel with you. You're the best. Bless you!
Got it!!! Your explanation is very clear and you give some example to support your data!! Well done you!! :)
Thanks. Saved so much time
Thanks very helpful love the way y explain
Thanks alot boss, have been suffering by adding them separately,ie consuming alot of time
thanks sir your tutorial was very clear
Nice explanation. Thank You.
Thank you for this tutorial! It is so helpful.
Thank you Sir ! It really is helpful .
Simple and to the point. Love it!
Apnr content gulo khub valo
Thank you very much. It solved my problem
Thanks for your great explanation, now I can play with this powerful formula.
Well done!! Thank you for sharing!
very clear tutorial
Great tutorial! I'm making my way through your videos.
Super helpful. Love using this function :)
You saved me! Thank you
Thanks. you made my day!
exactly what i needed. thank you.
Thanks, very helpful
thanks for explanation.
Thank you excellent tutorial
Geat job !! easy to follow. I am now a subscriber.
Awesome, thank you! Thanks so much for your kind gift.
Very useful!! Thank you very much!
Amazing. Keep up the great work.
Very well explained'., Hats off to you.But how do we got practise of that .?
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?
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.
Cntl + T
Terrific explanation!
Thanks, it was helpful!
Thank uuuuu super easy and understanble video
Thank you so much 🙏
YOUR AN ANGEL
Fantastic tutorial! :)
Awesome, thanks for sharing!
Thank you!
Love, love, love your videos. I've learned so much & realize how little I know. 😆 Great job! Keep them coming! 😊
Of coarse helpful..thank you v.much
Good Job Man easy explanation 1 more subscriber way to go champ!!!!!
Thank so much. your sharing.
That's a very useful formula.
Perfect video
Fantastic. Many thanks
hello and thanks ..this was really helpful
but i had a doubt how you will print the sumifs() value in another sheet
Thanks a lot dude!! 👍
Gave this a like! Thanks for the informational video
Awesome! Love excel!
Amazing video!
Very helpful, thanks a lot
Super Helpfull!
very helpful
Cool bro, thank you for sharing this video, it is really helpful
Thank you ❤
Smart, and very helpful indeed.
Nice job. Put an excel file in the description ...
Thank You
thanks. How would we frame this if we wanted to sum any format of >$5? Where would we include that in the formula?
Super helpful😊
So, it's basically a handy form of the AND function in excel for summing?
Great Video….
I am trying to make an Automatic Bowling Scoresheet. Any suggestions for the formula here?