Excel SUM and SUMIF Formula in Excel

Рет қаралды 326,100

Күн бұрын

Learn how to use the SUM function in Microsoft Excel to add values. See how you can add individual values, cell references or ranges or a mix of all three. Also learn how to use SUMIF to sum the values in a range that meet criteria that you specify.
=SUM(A2:A10) Adds the values in cells A2:10.
=SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.
You can practice with the sheet I used here: 1drv.ms/x/s!AmxrofZZlZ-whIZiN...
Watch more Excel tutorial videos: • ❎ How to use Excel
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
As full disclosure, I work at Microsoft as a full-time employee.

Пікірлер: 95

@KevinStratvert 4 жыл бұрын

⚡ Quick trick to sum a column in Excel. Place your mouse at the bottom of the list and then press Alt and =. Excel will then automatically sum the cells above. 🏫 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: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

@yhonfredyexcelformulas3784 3 жыл бұрын

Very good idea, congratulations on the information

@mangeshpowar 3 жыл бұрын

osum !

@felixmitchell6821 3 жыл бұрын

i guess it's kind of randomly asking but does anybody know of a good site to stream new series online?

@nicoxzavier3457 3 жыл бұрын

@Felix Mitchell Lately I have been using Flixzone. Just google for it :)

@jackmorgan9998 3 жыл бұрын

@Nico Xzavier yup, I have been watching on flixzone for months myself :D

@myriamkorstanje6922 Жыл бұрын

I'm glad your coworker asked you that one day. Many people just don't understand.Thank you for showing us.

@johnpinard3212 Жыл бұрын

Again, you have the best video on this. Your delivery is crisp, to the point, and you have the knack of being able to intuitively understand the questions to answer. Cogent, clear concise. Nice job.

@zon5308 Жыл бұрын

Thank you! that was very easy to understand for someone who has no experience with excel. You are terrific! Please continue making these videos. I would love it if you could show how to create a budget in excel for managing projects.

@petermoreno333 5 ай бұрын

Bro thank you so much!!!! This video is exactly on what ive been looking for. Im extremely new to excel and sumif is what ive been looking for for a long time. God bless!!!

@Niko132 2 жыл бұрын

Such a sick video, very easy and informative. Thank you

@sathyanarayanansatagopan9069 3 жыл бұрын

Thanks a lot. Please explain date wise debit and credit total in two columns and balance in next line, just like in tally cash book.

@siyansiyananth8341 Жыл бұрын

Thank you very much I understand everything very very well and clean I can not believe how are you teaching you are a very very very good guider yes are the best thank you I loved it

@user-zn3yo1gf9v Жыл бұрын

thanks for your easy to understand video. Great teaching! easy to follow.

@johnparker7191 Жыл бұрын

thanks for putting this together!! super helpful

@fitriyeni1729 3 жыл бұрын

Useful and very simple to understand

@shameenatapattu3885 4 жыл бұрын

Really enjoy your channel man..Good content

@hotcakes0913 3 жыл бұрын

Thank you for this tutorial!

@isaacm653 Жыл бұрын

Too good to see Kevin's works always.

@leovasquez2407 Жыл бұрын

I really like your videos, you have helped me so much...the only Microsoft videos I watch are yours.

@Slix436 Жыл бұрын

Thank you that was resourceful 👍🏽

@louiserobards1689 2 жыл бұрын

Very helpful, thanks for explaining in simple easy to understand language. Brilliant!😃

@anthonylovett9652 4 жыл бұрын

Liked the video Kevin, I would like to see a video on the ABS function. This is something I can’t get to grips with. Thank you

@KevinStratvert 4 жыл бұрын

thanks for the note, I'll add it to my list of videos to create. Cheers!

@007Saby 5 ай бұрын

LIFE CHANGING!!! THANK YOUUUUU!!!!!

@yelnatsgib Жыл бұрын

thanks again...easy to follow

@anythingheme 3 жыл бұрын

hi Kevin, i liked your video tutorials may i ask if you have for SUMIF and SUMIFS? i can't seem to find in your lists =) thank you po

@joydiamante9416 2 жыл бұрын

thank you so much for this :)

@marwanibrahim6018 3 жыл бұрын

Thank you 😊💓

@lisadunham1781 4 жыл бұрын

Question? How do you add 3 or 4 numbers in one cell?

@hsan1839 3 жыл бұрын

Thank you ❤️

@vetman98 8 ай бұрын

Thanks for the education

@benbadillo3656 3 жыл бұрын

Thank you!

@nooby7710 4 жыл бұрын

Super man!

@sathyanarayanansatagopan9069 3 жыл бұрын

Please explain date wise debit and credit total in two columns and balance in next line.

@waveblaster22 Жыл бұрын

Thank so much!!!!😁😁😁😁

@familya5 9 ай бұрын

Is there a way to substract multiple horizontal cells automatically as we keep adding numbers?

@ajibolaodeyemi4336 2 жыл бұрын

Please Kevin, how do I add up even or odd numbers.. Thank you. Good evening :)

@tewodrostesfaye7726 2 жыл бұрын

THANK YOU

@topspeederalmond 3 жыл бұрын

Thank You

@walterbraun402 4 жыл бұрын

Thanks

@brendawoods9962 Жыл бұрын

Hi Kevin, how can I use an 0 vs 10 to represent a cell, for example 8+2=10 I need to use 0 instead of 10 in a cell

@carriecaldarera4254 Жыл бұрын

Is it possible to sum a range and add more if cell criteria is met? For instance, I have the sum for a row of 7 cells and I want to add 300 to the total for every "x" in the row below it.

@XLLearner_Courses 9 ай бұрын

Pro tips. SUM+IF , perfect combination

@janemiller1080 3 жыл бұрын

Are there videos on Access?

@Kimberly6384 Жыл бұрын

That’s clear as mud for beginners 😂

@ameryusof7320 Жыл бұрын

1st summarize is all i need. Excel is mindblowing isn’t?

@bhanukajayarathna7741 2 жыл бұрын

Thnks ❤

@thilaktangle Жыл бұрын

hi ,, how to make automatic split ups for a particular value, EXample ( if the sum is 36 = the split ups should appear automatically)

@jasonjessup8585 Жыл бұрын

Anyone know how to add and average cells that have certain words in them with no numerical value. For example: 9 cells say "wrong" and 2 say "correct". How can I get the percentage for those cells?

@juliotorres6868 Жыл бұрын

What if you have lets say 10 minus 2 minus 2? what would be the formula to get a positive number?

@Backaller 2 жыл бұрын

Cheers my G

@alicenana476 Жыл бұрын

Can i use multiple formula in one cell, like using sum then round down after that sumif, how can i type this correctly so it can works properly.

@soumiamoujane3695 2 жыл бұрын

What's the formula for totalling up Yearly shopping. Can I use autosum to total up a shopping list for the whole year?. For example can I type =SUM(D6:Z38 in Total box and click enter. And for monthly total do I use autosum by typing =SUM(D6:D38 in the total box and click enter?.

@timdepault133 Жыл бұрын

How would I sum up how many favorites you have?

@jojorabbit811 4 жыл бұрын

Please. Please.. keep posting videos.

@KevinStratvert 4 жыл бұрын

will do! Are there any topics that you would find valuable? I have a bunch of Excel videos in the pipeline :)

@jhervinprado3546 4 жыл бұрын

@@KevinStratvert ser plsss post a video how to get varriance and standard deviation though excel thank you new subscribers btw😊

@abbeypitahin6120 Жыл бұрын

Is it possible to combine SUM and SUMIF?

@ardasnnnn 11 ай бұрын

you saved me

@brandoc1958 10 ай бұрын

Hi, I am using a formula to come up with a sum but when I run a sum of all the results from the formulas it will not give me a told. Gather because it won't add the results when there is a formula there. Is there a way around this?

@user-mr9le9md1t 6 ай бұрын

How can i take of only selected cells using cell address thing??

@YesYes-jp3pg 5 ай бұрын

In Excel, what function should I use if I want to know the numbers whose sum value does not exceed one value?

@queenofmean4614 3 жыл бұрын

It’s good for my assistant

@RobertLoudon Жыл бұрын

Hi what do i do if i want to add ie £14.22 to a column ie a daily charge to be added to a previous day so over a couple of months it adds so i don't have to use a calculator for each day for example £424.92 + £14.22 = £439.14 + £14.22 = £453.36 and so on

@jasirmanakkamburath9685 Жыл бұрын

Sir, SUMIF not working when referencing a cell with a formula, any solution?

@lindaschofield4314 2 жыл бұрын

Someone once told me that you can display which cells are included by clicking on the cell with the total and then pressing a function key. I can't remember what it was. Can you remind me?

@sreejithbgs 2 жыл бұрын

Hi Linda its "f2" which displays the cells included in the function

@lindaschofield4314 2 жыл бұрын

@@sreejithbgs thank you!

@Papapine Жыл бұрын

Is there a formula for a count in between? Lol...(not even sure if I'm saying that right). Anyways let's say I want the count or total not the added value. So for instance 100 to 241 I don't want total if added altogether 341 but 141 the amount from 100 to 241. TIA

@gr8fulsoul 3 жыл бұрын

@Kevin Stratvert Your practice sheet is Viewing only.

@KevinStratvert 3 жыл бұрын

I think that's intentional. Feel free to make a copy of the sheet. I didn't want people going in and changing the sheet -- that way it stays in its original state.

@gr8fulsoul 3 жыл бұрын

I thought that copying and pasting didn't transfer well in Excel. What am I missing?

@user-hh6vq5tb3b 6 ай бұрын

Please help me I am trying to find total of some payments done to be Now I have the total but I don't know how find that this payment is of these many bills Please help me soon

@govendnawzad4416 Жыл бұрын

👍

@queenofmean4614 3 жыл бұрын

👍🏽👍🏽👍🏽👍🏽👍🏽👍🏽👍🏽👍🏽👍🏽👍🏽 🤗

@kaythemilkshake 3 жыл бұрын

Kevin you kinda cute 😅

@ImranMalik-mg5uv 6 ай бұрын

Too much intro

@ashleyh1102 4 ай бұрын

How the heck did your coworker get a job at Microsoft and didn't know how use a basic function of Excel? I'm upset, HIRE ME!

@user-wg1hj8je2u Жыл бұрын

4:54 Funniest shit I've seen

@aliciaisip716 3 жыл бұрын

im here for math

@goduinn3074 10 ай бұрын

put a $ in front of the number and it wont work!!!!

@ibrahimkhurram610 3 жыл бұрын

Bruh 8mins vid for just SUM function, are you serious?

@hanrealistic 3 жыл бұрын

talking too much pal

@dineijahattidore-charles4435 2 жыл бұрын

I think everyone else can agree that he spoke just enough

@hanrealistic 2 жыл бұрын

@@dineijahattidore-charles4435 You think? Good. Most people are searching for something specific when it comes to technical stuff and wants to get to point straight away. Too much talking will result, the viewer to look for another video. You can ask the owner of the channel to show you video statistics.

@dineijahattidore-charles4435 2 жыл бұрын

@@hanrealistic You really got too much time on your hands lol. You can type all that, but can't watch an 8-minute video. I don't have time to read all that

@hanrealistic Жыл бұрын

@@dineijahattidore-charles4435 BUT YOU HAVE TIME TO WATCH, DON'T YOU? :)