How to use the SUMIF function in Excel 

no obnoxious intros and no time wasted. Just a straightforward explanation of the function I needed. THANK YOU!!!!

This is excellent. I echo all the comments about how concise and comprehensive these videos are.

Thanks for not wasting time.

thank you so much for explaining this quickly, concisely, and efficiently. Thanks

These videos are easily understandable fr fr. 100% would recommend

......accurate, understandable and right to the point. i will seek out more of your tutorials.

I love it. Great work. I wish every tutorial on the net was communicated so well. THANK YOU.. #learnexcel #excel #sumifs #enjoylife

Love u, You are a the best teacher.

Thanks for being short and clear video

Great simple easy to follow explanation!!!! and quick video!! quick, simple, to the point. Thank you! I'm an accountant and this is super useful. I'm subscribing.

Just exactly what I wanted to see

Thank you so much 😊 This was really helpful for last minute studies

you should make all video on excel....actually there are huge videos in youtube but most of the videos are very hard to understand. Your video quality is really appreciated.

Very easy to follow. Thank you for sharing!

God bless you for this thank you 🙋‍♀️

Very useful video specially writing text being showed on side

thank you! this is how I like it striate to the point

So helpful! Thank you!!

Very helpful thank u

Really helpful😘😘

Usefull and easy understandable

Thank you!

it was helpful in deed

wonderful. Thank you so much!

you're the best!!!!!!

I love it so much

Agree with Amanda Dude, straightforward, concise, clear approach to explaining how the formula works. For future instructors developing instruction tools, intro commentary that explains how Excel formulas i.e. SUMIF et al are used and applied in data analytics for business or social science is useful. Otherwise an extended commentary detracts from the real focus of instructional videos. Thx so much for sharing this Excel tool aid. :-)

Thank you

Beautiful!

Thank youu!!

thx so much i have an assement twrw and thosll help

Thanks Ma'am

This is actually easy wow

I don't know who she is but he has my heart! this was exactly what I was looking for! Thank you!!

Your way of explaining is very effective. Go ahead for more videos. Best of luck!!!

Like this short description.. a new subscriber

Thanks a lot for the tutorial, I just did my homework! :)

Das is good! 😊

In SQL sumif is equivalent to saying Select year, sum(value) where year = 2000

THANK YOU VERY MUCH! I ALREADY WATCH YOU OTHER TUTORIALS LIKE AVERAGE IF, COUNT IF... AND THIS IS A BIG HELP

Indeed a great explanation. I have follow up question , how to update the sumif range if a new row is added.

Wow, literally had to click out of 8 videos who were wasting time until this one gave me the answer I’m was looking for. Thanks again.

Thanks a ton for saving time.

had gone thru almost 10 videos on sum-if, found this one useful! thankyou for not wasting my time... :)

well job

Thank you so muchh

Very nice, not a bunch of yap yap.

OMG THANKS A LOT U R TOOO GREAT XD

I looked at 3 other yt first. your made sense. Thank you. 😀

This was very helpful, and to the point! Thank you genuinely for saving my day!

thank you !!!!!!!

THANK YOU SO MUCH!!!!!!!!!!!!!!!!!! I had a major issue trying to use vlookup for a value on another sheet out of a list of values, but it would only return one result and not all matches. I wanted it to match every result. Everyone on every website on Google said to use vlookup inside of sumif. I spent about 2 hours trying to figure that out. I came to this video and realized that I DO NOT NEED VLOOKUP! I was able to reference a value to the left in the same row and use that to search a separate sheet. Formula ended up being this =SUMIF(outage!B2:B400,OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-5),outage!E2:E400) .. So thankful for this video.

Wow!! Great so simple but useful

Great video. Straight forward and to the point, great explanation and good video quality. Subscribed :)

Thanks much👍

THANKS!!! REALLY HELPFUL, I WAS STOCKED

Thank you. Exactly what I was looking for

Fast and easy. You're great. Thanks

Thank you . I was struggling this will be my starter.

Searched RU-vid far and wide for this succinct and eloquently executed formula! Dope video, and helped me tremendously!!

Very helpful video. Thanks.

Good sharing, Mom

Very helpful thanks

Thank you - really concise and simple explanation

Thank you so much

Thank You so Much

thank you so much

great video

Thank you

NICE WORK

so very nice

Simple and straightforward. Thank you very much!

Excellent!

It is given the file.

Thanks

excellent explanation. thanks

excellent

again, many many thanks for your clean and clear tutorial.

i burned my previous pc because of this function keeps giving 0 value.

ty'

Nice tutorial ❤

SIMPLE AND STRAIGHT TO THE POINT, NO BS! SUBBED AND LIKING THE VIDEO

Right to the point!👍🏻

So helpful 😊

Great Video!

About 1 milion views and just 30k subscribed!

Very good 👍 👏

Wow, this was the best - to the point - laymen's terms tutorial I've ever seen :). Thank you!

Thanks, but can't we just filter the year 2000 and add all the values corresponding to it?

👏👏👏👏👏

Really amazing!!

👍👍

when I don't enter a sum_range value the formula doesn't work. help please

Thanks this really helped me with an IGCSE past paper😊

❤️❤️❤️

Thank you very much. It helps me a lot

Thank you!

You said a lot without saying anything at all

Just came for Assignment and this really explained well

can you do If ERROR