Excel SUM and SUMIF Formula in Excel

Поділитися
Вставка
  • Опубліковано 27 сер 2024

КОМЕНТАРІ • 98

  • @KevinStratvert
    @KevinStratvert  4 роки тому +33

    ⚡ 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: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html

    • @yhonfredyexcelformulas3784
      @yhonfredyexcelformulas3784 3 роки тому +1

      Very good idea, congratulations on the information

    • @mangeshpowar
      @mangeshpowar 3 роки тому +1

      osum !

    • @felixmitchell6821
      @felixmitchell6821 3 роки тому

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

    • @nicoxzavier3457
      @nicoxzavier3457 3 роки тому

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

    • @jackmorgan9998
      @jackmorgan9998 3 роки тому

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

  • @myriamkorstanje6922
    @myriamkorstanje6922 Рік тому +7

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

  • @johnpinard3212
    @johnpinard3212 Рік тому +5

    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.

  • @siyansiyananth8341
    @siyansiyananth8341 Рік тому +2

    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

  • @petermoreno333
    @petermoreno333 6 місяців тому +1

    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!!!

  • @zon5308
    @zon5308 Рік тому +1

    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.

  • @MuralidharKalidasu
    @MuralidharKalidasu 19 днів тому

    Hi Kevin, seek your guidance for the following:
    how to add or deduct a value in a cell basing on the sign of outcome of subtracting value from previous two cells. Here is an example: A - B = C where A and B are independent positive variables. However, the outcome in Cell C could be positive or negative basing on the values of A and B. Next Step is - C + or - D = E, where C could be a +ve or -ve number. & D is a +ve number. If C is +ve, value in D is to be deducted else value in C is to be added to value to D, which will be populated in Cell E.
    Request you to guide how to write a single line command in excel

  • @leovasquez2407
    @leovasquez2407 Рік тому

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

  • @isaacm653
    @isaacm653 Рік тому

    Too good to see Kevin's works always.

  • @sathyanarayanansatagopan9069
    @sathyanarayanansatagopan9069 3 роки тому +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.

  • @Niko132
    @Niko132 2 роки тому +2

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

  • @fitriyeni1729
    @fitriyeni1729 3 роки тому +2

    Useful and very simple to understand

  • @Slix436
    @Slix436 Рік тому +2

    Thank you that was resourceful 👍🏽

  • @louiserobards1689
    @louiserobards1689 2 роки тому +3

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

  • @anthonylovett9652
    @anthonylovett9652 4 роки тому +1

    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
      @KevinStratvert  4 роки тому

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

  • @ameryusof7320
    @ameryusof7320 Рік тому

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

  • @johnparker7191
    @johnparker7191 Рік тому +1

    thanks for putting this together!! super helpful

  • @user-zn3yo1gf9v
    @user-zn3yo1gf9v Рік тому

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

  • @XLLearner_Courses
    @XLLearner_Courses 10 місяців тому

    Pro tips. SUM+IF , perfect combination

  • @Kimberly6384
    @Kimberly6384 Рік тому +1

    That’s clear as mud for beginners 😂

  • @007Saby
    @007Saby 6 місяців тому

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

  • @maurod469
    @maurod469 3 дні тому

    Can you export one name like Pension to a spreed sheet for all the cells it occupies for a year?

  • @lisadunham1781
    @lisadunham1781 4 роки тому +2

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

  • @yelnatsgib
    @yelnatsgib Рік тому

    thanks again...easy to follow

  • @YesYes-jp3pg
    @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?

  • @shameenatapattu3885
    @shameenatapattu3885 4 роки тому +1

    Really enjoy your channel man..Good content

  • @vetman98
    @vetman98 9 місяців тому

    Thanks for the education

  • @excelal642
    @excelal642 19 днів тому

    Heyyo i wanna ask something. If you can add multiple number using sum function, is there any formula that doing that but in reverse?
    Instead you got a total number for it, is there any way to convert a total number into divided number and separate it in column?

  • @sathyanarayanansatagopan9069
    @sathyanarayanansatagopan9069 3 роки тому

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

  • @familya5
    @familya5 9 місяців тому

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

  • @user-mr9le9md1t
    @user-mr9le9md1t 7 місяців тому

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

  • @hotcakes0913
    @hotcakes0913 3 роки тому

    Thank you for this tutorial!

  • @timdepault133
    @timdepault133 Рік тому

    How would I sum up how many favorites you have?

  • @brandoc1958
    @brandoc1958 11 місяців тому

    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?

  • @soumiamoujane3695
    @soumiamoujane3695 2 роки тому +1

    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?.

  • @juliotorres6868
    @juliotorres6868 Рік тому

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

  • @joydiamante9416
    @joydiamante9416 2 роки тому +1

    thank you so much for this :)

  • @carriecaldarera4254
    @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.

  • @alicenana476
    @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.

  • @thilaktangle
    @thilaktangle Рік тому

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

  • @brendawoods9962
    @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

  • @anythingheme
    @anythingheme 3 роки тому +2

    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

  • @jasirmanakkamburath9685
    @jasirmanakkamburath9685 Рік тому

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

  • @jojorabbit811
    @jojorabbit811 4 роки тому

    Please. Please.. keep posting videos.

    • @KevinStratvert
      @KevinStratvert  4 роки тому

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

    • @jhervinprado3546
      @jhervinprado3546 4 роки тому

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

  • @jasonjessup8585
    @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?

  • @waveblaster22
    @waveblaster22 Рік тому

    Thank so much!!!!😁😁😁😁

  • @ajibolaodeyemi4336
    @ajibolaodeyemi4336 2 роки тому

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

  • @user-hh6vq5tb3b
    @user-hh6vq5tb3b 7 місяців тому

    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

  • @gr8fulsoul
    @gr8fulsoul 3 роки тому

    @Kevin Stratvert Your practice sheet is Viewing only.

    • @KevinStratvert
      @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
      @gr8fulsoul 3 роки тому

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

  • @tewodrostesfaye7726
    @tewodrostesfaye7726 2 роки тому

    THANK YOU

  • @abbeypitahin6120
    @abbeypitahin6120 Рік тому

    Is it possible to combine SUM and SUMIF?

  • @lindaschofield4314
    @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
      @sreejithbgs 2 роки тому +1

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

    • @lindaschofield4314
      @lindaschofield4314 2 роки тому +1

      @@sreejithbgs thank you!

  • @RobertLoudon
    @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

  • @benbadillo3656
    @benbadillo3656 3 роки тому

    Thank you!

  • @nooby7710
    @nooby7710 4 роки тому +2

    Super man!

  • @marwanibrahim6018
    @marwanibrahim6018 3 роки тому

    Thank you 😊💓

  • @queenofmean4614
    @queenofmean4614 3 роки тому

    It’s good for my assistant

  • @ardasnnnn
    @ardasnnnn Рік тому

    you saved me

  • @hsan1839
    @hsan1839 3 роки тому

    Thank you ❤️

  • @janemiller1080
    @janemiller1080 3 роки тому

    Are there videos on Access?

  • @topspeederalmond
    @topspeederalmond 3 роки тому

    Thank You

  • @ImranMalik-mg5uv
    @ImranMalik-mg5uv 7 місяців тому +3

    Too much intro

  • @sumitagiri2304
    @sumitagiri2304 4 роки тому

    Thanks

  • @Backaller
    @Backaller 2 роки тому

    Cheers my G

  • @bhanukajayarathna7741
    @bhanukajayarathna7741 2 роки тому

    Thnks ❤

  • @Papapine
    @Papapine 2 роки тому

    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

  • @ashleyh1102
    @ashleyh1102 5 місяців тому

    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
    @user-wg1hj8je2u Рік тому

    4:54 Funniest shit I've seen

  • @goduinn3074
    @goduinn3074 11 місяців тому

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

  • @aliciaisip716
    @aliciaisip716 3 роки тому

    im here for math

  • @govendnawzad4416
    @govendnawzad4416 Рік тому

    👍

  • @kaythemilkshake
    @kaythemilkshake 3 роки тому

    Kevin you kinda cute 😅

  • @BeastOrGod
    @BeastOrGod Місяць тому

    yeah, we don't need your lifestory

  • @queenofmean4614
    @queenofmean4614 3 роки тому

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

  • @ibrahimkhurram610
    @ibrahimkhurram610 3 роки тому

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

  • @nagasrinivasvankadari1521
    @nagasrinivasvankadari1521 Рік тому

    poor explanation ,was not useful

  • @hanrealistic
    @hanrealistic 3 роки тому

    talking too much pal

    • @dineijahattidore-charles4435
      @dineijahattidore-charles4435 2 роки тому +3

      I think everyone else can agree that he spoke just enough

    • @hanrealistic
      @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
      @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
      @hanrealistic 2 роки тому

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

  • @walterbraun402
    @walterbraun402 4 роки тому

    Thanks