SUMIF Function in Excel Tutorial

[@KevinStratvert]

🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

[@hablooey]

Just 2 hours!

[@evanscott1204]

do you need to have specefic spreadsheet to do each function

[@seliphawaigwa1981]

Anyone else who attempted the 1st example of SUMIFS multiple rows formula and still got a zero(0) instead? How did you get it to show 28 and 32?

[@Zinu26]

It didn't worked for me it says "you've entered too few arguments"

[@angrywalrus3761]

That’s the exact problem I’m having right now! If you ever figured this out could you please let me know

[@humphreynjuguna8934]

Im getting a zero too

[@lewis8983]

There's alot of tutorials about excel on youtube but your tutorials are easy to understand! ty

[@jethrobo3581]

using ver. 2019 (version 2204 (build 15128.20224) - on the sumfs function - it won't give the array (as it does w/your version). Tried several times to be sure I was doing just as you did. Have you any idea what's wrong? BTY: Love your videos!

[@dwang085]

I’m a big fan of how you always show the insert function process. a lot of tutorials just do it all in the cell or the formula bar which is fine, but using the insert function really adds a little something extra. It’s those kind of things that are the reasons the KCC is at the top of its game!!🤩👨‍🍳🍪🍪🍪

[@Jakeindbox]

Easily the best tutorial maker on KZbin. My new job makes a lot of use of the Sumif formulae and this definitely helped me understand it more!

[@UsmanKhan-cj5vn]

Sir with due respected we need tutorial on VLOOKUP also .Thank You

[@learningwithmaliha]

Explained beautifully the very confused concept of Sumif and its family.

[@neo778]

Excel is funny in foreign languages, when you have to translate all this commands 🙈

[@theeditorlegacy2416]

One of the best thing about dude is that he never takes credit for himself ❣️❣️keep growing bro... All the best

[@naglaa99]

Please I want video about cube function

[@rickytomun5525]

Thank you so much. I really appreciated this video. I'm on a deadline at work and I have no excel training. This video really helped me. 👍 Kevin and 👍 for creating contents that help users

[@rickytomun5525]

Thank you so much. I really appreciated this video. I'm on a deadline at work and I have no excel training. This video really helped me. 👍 Kevin and 👍 for creating contents that help users

[@kofimaracktv]

Hello sir, please I need assistance writing VBA codes to insert passport pictures into picture content in MS Word document if about 20 pages. James, Ghana, West Africa. Thank you.

[@TTM111]

Ok

[@austinboyd5363]

Can you use =SUMIF to add .05 cents on the dollar for beverage crv tax for below 24 oz and .10 cents on the dollar for above 24 oz? Or is there a different method for that?

[@iESTO818]

What if my criteria includes being withing a certain time period? Lets say the cookie transaction dates for each cookie type were tracked and i wanted to know how many chocolate chip cookies were sold in the US this month (there is data from the previous months). How would i ago about including that criteria?

[@tsamichuzyme2658]

We appreciate your efforts making these informative and education videos. These content are definitely valuable to all people using Excel at work and schoo. Thank you so much for the help.

[@zaslam3547]

How did you get that theme in your excel?

[@prokorshopal4865]

0:00 - Hi Kevin. 👋 11:26 - Definitely 416th thumbs up from me to the stunning video. 👍 Cheers.

[@RogerStocker]

I only use the =*IFS() functions since they are available just to have always the same syntax regardless the number of criteria(s).

[@fernandodominguez4522]

I subscribed because I learned the SUMIF function in 40 seceonds.

[@yourfavoritetiktokers4112]

I love your humour, its fun to watch even if its just for a second

[@bilkissultana7807]

Kevin randomly asking to subscribe ( 0:37 ) was nice

[@briankelly1240]

The random management question is the most accurate 🤣

[@wangzig9800]

Excellent Tutorial as always!.. "Sumifs" could be used in many things like calculating items in store/inventory. at school how many kids in such class and how many classes in such institute and how many in different locations. Thanks for this Tutorial.

[@KevinStratvert]

Great tip!

[@ra5hid101]

Consider making a fulll course on Excel with the new version. Thanks for the vid.

[@KevinStratvert]

Full course coming soon 👍

[@CarnisChampion]

sumif one of the most useful functions :D

[@mahiaslam6738]

dude, why you are so great at teaching Excel? Man I wish I have teacher like you for all of my subjects.

[@seanleastria4478]

I don't understand. There's no explanation on MS store. How to install MS Store apps to other drive? If you have your main drive with windows OS and high speed SSD, the only thing needed on there is a few games that require high speed to win. All other games and software can be installed in second drive. Also, how to install Chrome to second drive?

[@sia6410]

I like it the way you say "today".. thank you for the vids

[@naglaa99]

Good

[@divyeshnagesh1174]

hi

[@jasonluong3862]

Kevin's Cookies only sold 158 cookies in the world. How can it still stay in business?

[@KevinStratvert]

We're very effective at 'selling' the vision and dream to investors 😅

[@karinarzz]

I always recommend your videos to coworkers that want to improve their skill set.

[@KevinStratvert]

Thanks Karina! Much appreciated 🙏

[@dennisrasilez]

Nice info. Thanks

[@Kikamalak]

After watching this video and practicing using the workbook, I feel like I am now an expert. Thanks so much Kevin!

[@KevinStratvert]

Happy to help!

[@AnushkaDixit-yp6ur]

@Kevin Stratvert your way of explaining formula's is just amazing.

[@sandramurphy5165]

Thanks Kevin. Your tutorial was very good to watch. I got a real lightbulb moment and now I can't wait to start applying this to spreadsheets where I have always manually totalled colums using the SUM tool and worked out the rest manually.

[@sirmium12]

One of your best tutorials regarding Excel...

[@databurst]

Hey Kevin, I don't know why I am getting zero as result in sumifs multiple rows. I double checked and i am entering the same formula as you, I even changed the country from United States to India but then I am getting only 75 instead of 107 in result when I selected chocolate chip and oatmeal raisins. Could you or anyone help me with this? this is the formula that I used : =SUM(SUMIFS(C:C,B:B,B2,A:A,A2:A3))

[@vfakatoumafi]

your tutorial is simply the best out of all the other videos I watched! Thank you!

[@iceicebuddy]

Extremely unhelpful

[@anv.4614]

Thank you Kevit, Great.

[@maywanng5614]

Is great teaching, this is almost a full set for the sum, count, average so and so for one set of sum examples. However, if you can speak slowly and clearly especially like the * and ?. For the ? there is no example shown and also can't find the sample worksheet below. Last, the formula shown in xls next to your answer also never shows us how it appears there :( I told my mom you are so great in your teaching and xls :) Thanks, Great teacher :)

[@pendoring282]

very useful and helpful thank you.

[@mdsiam9687]

My "SUMIFS Multiple Rows" is giving "0". Could anyone possibly give the solution?

[@caromoneypenny8684]

Kevin, you are the best!

[@peachycheeks4394]

Thank you!

[@KevinStratvert]

You bet!

[@robertcoleman780]

Awesome video as always

[@KathyFors]

Hi Kevin, how to get rid of red circles in the cell. it's not a Comment. But, random red dots. Can you help? I can send you a screen shot.

[@amitabhagupta4224]

Thanks for the tutorial of Excel function. Just wondering does these 2 functions work in the same way in Google Sheet too?

[@KevinStratvert]

Mostly the same. Google Sheets doesn't seem to support multiple criteria in the same column like with Excel. It does however support multiple criteria in different columns.

[@amitabhagupta4224]

@@KevinStratvert Thank you so much

[@technicalstuffinfo]

I like the way he says kevin here.. Informative video 👍

[@senyotsedze3388]

the multiple row sumifs is returning 0 when I put in the formular you gave. Am I doing something wrong

[@querrythis]

Thank you very much Kevin. I was trying to add random numbers within a range based on values in an adjacent cell. After getting very complex with my formulas, it was this logical sumif that did it. Just goes to show, it doesn't always have to be complex. Can't thank you enough.

[@QuazarGraphics]

1st 😍❤

[@TheSeeking2know]

Always educational!

[@JustBlankNoInfo]

An Excel Masterclass!

[@bellablanco2502]

Hi do you have excel recommendation to use for free? What excel do you use ?

[@farrinlavar]

Awesome content! BTW “A WALK TO REMEMBER” You are giving Shane West vibes

[@FreedomTalkMedia]

The part when he asked us to subscribe was so awkward, but that's totally appropriate for an Excel video. LOL!

[@hablooey]

Yo bro thanks really helpful for studying for school although i'm never gonna use Excel

[@wncjan]

For multiple criteria sums or counts I prefer to use SUMPRODUCT(), which in my opinion is more versatile and do both AND and OR criterias. Maybe you could do a video on all the ways you can use SUMPRODUCT.

[@RogerStocker]

since Excel has the new array functions the SUMPRODUCT() is less ans less needed.

[@wncjan]

@@RogerStocker Yes. For those who have a recent version of Excel. But I can see from questions I get that many have much older versions.

[@jeffkabs2394]

Hello, I would like to create a workbook for a savings and credit cooperative. This workbook would need to auto-update with years, past, present, and future months. The months would need to range from 2023 to infinite, and the years would need to range from 2023 to infinite as well. The workbook would need to track member id or account names and payments made of deposits, savings, personal accounts, loans received, loan payments, etc. Is this something you can help me with?

[@lauratwesigye6009]

Kevin, I have data, and its as follows. I have total number of participants that attended a training, some are direct others are indirect, some are female others are male, they are in different age groups. When I use this formula =SUMIFS(L13:L6568,M13:M6568,M13,N13:N6568,N13,O13:O6568,O13), and this does not help as a data entrant continues data entry. What can I do? 😭😭😭😭😭😭😭😭I really need your help.

[@peggylouie7624]

Thanks for showing us what sumif is all about, I used to do the same thing using pivot table :)

[@KevinStratvert]

Pivot tables work just as well 👍

[@3moirai]

Another great tutorial. How did you get column G to show the formula in the adjacent cell in F?

[@KevinStratvert]

You can use the formulatext function 👍

[@3moirai]

@@KevinStratvert awesome! Thx

[@davidtravers922]

Kevin, I just getting back into using Excel for my Master's degree and for work. How do I group your KZbin vides in sequence?

[@eztt6304]

Yo, thanks!

[@VybzWithDerr]

I really appreciate your help because I didn’t understand before but now I fully understand.

[@dbmnfinity1]

Bro! I love this..... thank you, ? please..... can you do this with names? I need to track the percentage of employee's ( by name) that have the highest percentage of QA surveys......not sure if you answered a question similar to this, but I'm gonna ask anyway :)

[@ManiMani-hb1jr]

You know the way you are doing is quite cool nd worthy🤩

[@franklanderer]

This was super helpful, thank you!

[@tekmepikcha6830]

Oh so useful!! thank you. I need to watch the last non-adjacent example again....didn't stick with me lol

[@mr.2d652]

Thank you for this very helpful learning video. really upskills those who don't have any experience and knowledge in excel

[@pderoo1]

Well dayum. Now I want cookies 😕

[@bobgasylvie6202]

You have the best teaching approach ever. so simple so great. i found my new excel teacher. thank you, please keep it coming.

[@sebastiandtorres]

Hi Kevin. Do you know if the goal seek function is available for Excel in Android? Thank you very much. Best Regards!

[@nemrabboud4636]

Hi. In sheet1 have a column with 4oo names and in sheet 2 I have a column with 60 names. I need to find which names in sheet 2 exist in sheet 1 and give me the row numbers they are in. What function does that?

[@violetheise4717]

I know it was cheesy, but the little joke at the beginning genuinely made me laugh. Thanks for all the great tips and guidance.

[@YY-bk9bc]

Excellent! Easy and clear to follow

[@bisikiki7291]

You're killing me!.... U have a pleasant personality.

[@KarenC-nr7tf]

Kevin equals a "chocolate cookie"

[@sirthomas9835]

Great vids - quite helpful, Thanks Is there a way to increase the font size within the Excel program? Like where you are in File>Options. It just seems like an 8 font!

[@REAZULKABIR-x2m]

Sample workbook is not working

[@sornthanh7212]

Thank for sare watch from Cambodia southeast Asia 🇰🇭

[@jeevanmarg]

Awesome examples.

[@ayekm22]

Thanks,Kevin,I've been learning excel functions from your lecture videos and that helps me a lot..

[@AnNguyen-rx2xe]

Great video, I learnt something new on the Sum over Sumif!

[@alicoustic3155]

THIS GUY IS IN LOVE WITH COOKIES.

[@lezandravinoya9235]

Hello there Kevin,, Im a fan fr Philippines ❤️

[@veronicadavila3180]

I've seen most of your videos, my Professor uses you as a reference, you make it seem so effortless😞

[@GPHomeFinder]

Hi Kevin. Could you show us how to add a column that is a function of furmulas? IE we have 7 rows of column a-b =c. It always goes to error when trying to sum column c

[@ChadCoots]

Simple tutorial and super helpful. Tks

[@jsmcguireIII]

TY Kevin!

[@jackbenhaim9197]

Great! Explained in a simple but clear! Thank you

[@jacquelineohayon507]

Thank you again for another awesome video!

[@a.achirou6547]

Thank you very much.

[@godfred8002]

❤❤❤❤❤

[@MzLewis29]

Great tutorial