How to use the SUMIF function in Excel

Learn how to use the SUMIF function in Microsoft Excel. This tutorial demonstrates how to use Excel SUMIF with an easy to follow example and takes you step-by-step through the different options when entering your formula.
SUMIF Function (and sample data):
www.techonthenet.com/excel/fo...
Excel Tutorials:
www.techonthenet.com/excel/in...
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: www.techonthenet.com
or follow us on:
Facebook: / techonthenetcom
Twitter: / tech_on_the_net
Pinterest: / techonthenetcom

[@amandadube156]

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

[@Techonthenetcom]

Thanks Amanda :)

[@jeanettesefers8180]

Yes, I loved that about this tutorial!!

[@jazibaliwaheedkhokhar1471]

Thanks for not wasting time.

[@tracipelletier2033]

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. :-)

[@r.o.1330]

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

[@goodlife6145]

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

[@ulyssesemmanuel]

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

[@rubyweiss6209]

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

[@arnellcarmichael635]

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

[@ndabenhlengubane4921]

Simple and straightforward. Thank you very much!

[@JosueGomez520]

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

[@Techonthenetcom]

Thanks for watching! :)

[@RaulJose1111]

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

[@satishsingh6861]

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

[@mahfuzarrahman8897]

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

[@nainatalwar8095]

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

[@richmondzoilo9667]

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

[@Techonthenetcom]

Thank you for supporting the channel!

[@anony88]

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.

[@Techonthenetcom]

That's so great! :)

[@kesarduggar1067]

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

[@timcraven3543]

Fast and easy. You're great. Thanks

[@cheriecejohnson6680]

Thank you. Exactly what I was looking for

[@linthitoo7476]

Just came for Assignment and this really explained well

[@jaded_dahlia]

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

[@a.y.greyson9264]

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.

[@Techonthenetcom]

Glad it helped!

[@sunriseeternity300]

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

[@Techonthenetcom]

Thank you very much!

[@jeanettesefers8180]

Very easy to follow. Thank you for sharing!

[@lakshmanprasad4761]

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

[@Techonthenetcom]

Glad it helped!

[@mohammadsalmansayed3792]

Thanks a ton for saving time.

[@musicdukhoo3004]

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

[@guyedema7387]

Thank you - really concise and simple explanation

[@addisasfaw1969]

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

[@dudehere1981]

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.

[@62-anikamubasshira54]

Like this short description.. a new subscriber

[@segundamilola6180]

Just exactly what I wanted to see

[@drdghattierdc]

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

[@preetimaggon2071]

Thanks for being short and clear video

[@User-rx9ko]

God bless you for this thank you 🙋‍♀️

[@imraneng]

Love u, You are a the best teacher.

[@jimerlynsiao7578]

Wow!! Great so simple but useful

[@savanahencelewski6321]

So helpful! Thank you!!

[@holteriv]

THANKS!!! REALLY HELPFUL, I WAS STOCKED

[@tysonclarke012]

wonderful. Thank you so much!

[@njokuochafrancis3688]

Nice tutorial ❤

[@LeochrisWanangwa-tq7ud]

Very helpful thank u

[@rogeliosantiago3237]

Thank you very much. It helps me a lot

[@elmirabbasoglu]

Very helpful video. Thanks.

[@itachiuchiha1734]

Thanks much👍

[@bonumventura]

Thanks this really helped me with an IGCSE past paper😊

[@Techonthenetcom]

Glad it helped!

[@leennfh1651]

Thank you so muchh

[@subramanirangasamy3320]

Usefull and easy understandable

[@demensclay6419]

Excellent!

[@Syuzienglishbulldog]

Very helpful thanks

[@mohammadzahid2721]

Very useful video specially writing text being showed on side

[@Techonthenetcom]

Glad it was helpful!

[@thejackleader]

So helpful !!

[@nivednk500]

Thank you!

[@mellamovicky90]

excellent explanation. thanks

[@plamenyankov8476]

Beautiful!

[@hulutube4399]

thank you !!!!!!!

[@SL-jn4em]

Right to the point!👍🏻

[@celacademy8316]

NICE WORK

[@annelorrainemoreno8399]

Really amazing!!

[@tapasya24x7]

Thank You so Much

[@cameronchanning9468]

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

[@Techonthenetcom]

Thank you!

[@whosam0]

Great Video!

[@surbanoclarabel5544]

Thank youu!!

[@MrRtorres8915]

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

[@ahmadzannoun7437]

Thank you so much

[@TEBCO123]

great video

[@Sasainsa]

Really helpful😘😘

[@followdg]

Thank you for this video. Very informative and straight to the point!

[@user-os6dv5xb2b]

So helpful 😊

[@Papi_21]

This is actually easy wow

[@user-in5wp8yo2i]

Das is good! 😊

[@yalobeko7978]

Thank you

[@johnnaweza3186]

it was helpful in deed

[@Anush_Sivakumar]

OMG THANKS A LOT U R TOOO GREAT XD

[@walubillz5631]

you're the best!!!!!!

[@mahfuzarrahman8897]

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.

[@phuthyboy7467]

I love it so much

[@abdulrehmankhan9584]

well job

[@ClimateScienceForTheWorld]

Very good 👍 👏

[@khalidwaheed846]

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

[@aaronfrancis276]

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

[@amitagarwal8646]

excellent

[@samitadigal5424]

so very nice

[@connerwyataaji626]

thx so much i have an assement twrw and thosll help

[@lucianlackman8103]

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

[@jackwoodruff7661]

This person is a robot... a beautiful, helpful robot.

[@Techonthenetcom]

Not a robot! :)

[@martinfernandezcean]

Thanks

[@ankushkumar7374]

Thanks Ma'am

[@Techonthenetcom]

Most welcome 😊

[@ranjitmulay8089]

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

[@jelajahsebanten]

Good sharing, Mom

[@yellingification]

can you do If ERROR

[@AK-ox3mv]

About 1 milion views and just 30k subscribed!

[@clutchdiamond8891]

ty'

[@thea3530]

Very nice, not a bunch of yap yap.

[@ibrahimhamdi5917]

❤️❤️❤️

[@samanmaeruf]

👏👏👏👏👏

[@ubaidillahmuhammad20]

It is given the file.

[@adambrown5478]

Can SUMIF be used with letters as values, or just numbers?

[@akashhela8521]

👍👍

[@terrybohn2942]

like