How to Calculate Running Total in Excel (Formula, Pivot Table, Power Query)

แชร์
ฝัง
  • เผยแพร่เมื่อ 12 พ.ย. 2024

ความคิดเห็น • 58

  • @trumpexcel
    @trumpexcel  3 ปีที่แล้ว +4

    If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
    Also, I have made all of my Excel courses available for free. You can check these out using the below links:
    ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
    ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
    ✅ Free VBA course - bit.ly/excel-vba-course
    ✅ Free Power Query Course - bit.ly/power-query-course

    • @jaroldharveycapoy3001
      @jaroldharveycapoy3001 3 ปีที่แล้ว

      do you have an email where we can talk, i want to consult something about the video you make about drop down search to paste or show data, you used 3 helpers in that video

    • @korbynjasper807
      @korbynjasper807 3 ปีที่แล้ว

      pro trick : you can watch series at flixzone. Me and my gf have been using them for watching loads of movies these days.

    • @renejavion345
      @renejavion345 3 ปีที่แล้ว

      @Korbyn Jasper Definitely, been using flixzone} for years myself :D

    • @pa2happiness13
      @pa2happiness13 3 ปีที่แล้ว

      @@jaroldharveycapoy3001 th-cam.com/video/-su8Z4j1p1A/w-d-xo.html

  • @InsightfulJourney123
    @InsightfulJourney123 3 ปีที่แล้ว +1

    The best excel instructor ever on TH-cam!!!

  • @jiajiaphotography
    @jiajiaphotography 3 ปีที่แล้ว +1

    All of these methods are new to me. Thank you!

  • @IvanCortinas_ES
    @IvanCortinas_ES 3 ปีที่แล้ว +2

    Excellent tutorial Summit. Your explanations are always detailed and accurate. Thank you!!!

  • @wayneedmondson1065
    @wayneedmondson1065 3 ปีที่แล้ว +2

    Hi Sumit. Great lesson! Here's another one I like to use in tables: =SUM(INDEX([Sale],1):[@Sale]). Love that Power Query method! Thanks for sharing your tips :)) Thumbs up!!

  • @kashmoney1
    @kashmoney1 3 ปีที่แล้ว +2

    Thanks, Sumit....another way is to use the quick analysis tool when you highlight the data and use variety of considitonal formatting to running totals as well....👍

  • @patrickschardt7724
    @patrickschardt7724 3 ปีที่แล้ว +1

    It’s great to see so many solutions. Wonderful job

  • @cadjiton
    @cadjiton 2 ปีที่แล้ว +1

    Thank you Sumit, it's super easy

  • @ripudamansingh5732
    @ripudamansingh5732 3 ปีที่แล้ว

    Structure data header explained truly amazing.. Still lot of people fail to use incorrectly.

  • @salmnz
    @salmnz 3 ปีที่แล้ว +1

    Excellent teacher

  • @MareeTeolanafo
    @MareeTeolanafo 3 ปีที่แล้ว +1

    Great video! Thanks for sharing.

  • @ashishkapil259
    @ashishkapil259 3 ปีที่แล้ว +1

    Sumit is always best 👍👍👍

  • @khalidrehman5045
    @khalidrehman5045 3 ปีที่แล้ว +1

    Hi Sumit, nicely explained, thumbs up

  • @HusseinKorish
    @HusseinKorish 3 ปีที่แล้ว

    That's perfect ...i liked the power query solution

  • @onlyexcel493
    @onlyexcel493 3 ปีที่แล้ว +1

    You explain very well sir

  • @Immortalsouls
    @Immortalsouls 2 ปีที่แล้ว

    Thanks for this video! Amazing stuff! I really needed it!!

  • @RaviKumar-gz9my
    @RaviKumar-gz9my 3 ปีที่แล้ว

    Excellent. Nicely Explained.

  • @kushkhan3219
    @kushkhan3219 3 ปีที่แล้ว

    You are great sir .

  • @lucianapinheirofurquim7335
    @lucianapinheirofurquim7335 ปีที่แล้ว

    Excelente! Me ajudou muito! Parabéns e muito obrigada!

  • @fayazmuhammad5983
    @fayazmuhammad5983 3 ปีที่แล้ว

    Thank you sir for sharing useful information

  • @mohamedadjal8502
    @mohamedadjal8502 3 ปีที่แล้ว

    😃 thank you for this video

  • @umidjonqarshiev2746
    @umidjonqarshiev2746 3 ปีที่แล้ว

    You da man Sumit, Thank You!

  • @CarlosMoreno-vw4ir
    @CarlosMoreno-vw4ir 3 ปีที่แล้ว

    Thank you so much for this awesome lesson, to complete the "running total" tips, can you add the dax mesure for running total, thanks!!

  • @robertowerneck6902
    @robertowerneck6902 3 ปีที่แล้ว +1

    Great video!

  • @zaheerahmed9549
    @zaheerahmed9549 2 ปีที่แล้ว

    Excellent

  • @ripudamansingh5732
    @ripudamansingh5732 3 ปีที่แล้ว

    I thought next exp will come while explaining pivot sumifs with criteria. But thx serious job explained with example.

  • @TheSuvankarKundu
    @TheSuvankarKundu 3 ปีที่แล้ว +1

    Thts awesome sir

  • @onlyexcel493
    @onlyexcel493 3 ปีที่แล้ว +1

    Valueble video sir

  • @prafulchandekar4986
    @prafulchandekar4986 3 ปีที่แล้ว

    Well done sumeet

  • @sanjaysrivastava9671
    @sanjaysrivastava9671 3 ปีที่แล้ว +1

    Excellent as usual. How can I get all your videos please?

  • @yousrymaarouf2931
    @yousrymaarouf2931 10 หลายเดือนก่อน

    Fantastic

  • @amitgurav8495
    @amitgurav8495 2 ปีที่แล้ว +1

    Hi if i m typing formulae cell A1 and want to select range for A1 itself so is there any short key to create range say A1:A1

  • @vikaasb2016
    @vikaasb2016 3 ปีที่แล้ว +1

    Awesome

  • @singhalmonica
    @singhalmonica 3 ปีที่แล้ว

    Sir r u running any class to learn Google script language

  • @RaviPatel-kf5lk
    @RaviPatel-kf5lk 2 ปีที่แล้ว

    Hello Summit, What if there are multiple duplicate products in place of Dates in this example and we want to find the running total of other column how to use SUMIF function? Can you help me on this ?

  • @lalitchhaya5410
    @lalitchhaya5410 3 ปีที่แล้ว

    Can you please explain how to use 2 excel for making a pivot table output of required columns data

  • @mushfiqulislam8898
    @mushfiqulislam8898 ปีที่แล้ว

    if i have a forecast column how forecast also change according to sales data ?

  • @rajendrabajpai3565
    @rajendrabajpai3565 3 ปีที่แล้ว

    I like it

  • @nawazsharifcollege1515
    @nawazsharifcollege1515 3 ปีที่แล้ว

    manage running total of with drawl and deposit both with one formula please guide me in this regard.

  • @tanishqmairal
    @tanishqmairal 3 ปีที่แล้ว

    Can you share the formula or make a video on how use countif in excel power query.

  • @Shivdi1951
    @Shivdi1951 3 ปีที่แล้ว

    In col.d the formula could be sumif($c$2:$c2,d$1,$b$2:$b2)
    This can be copy pasted in next columns.

  • @shibilsnoopy3973
    @shibilsnoopy3973 3 ปีที่แล้ว

    Dear sumit,
    I need your kind help for some vba doubts. If my userform autofit with screen size also want to change textbox and list box autosize . I looking for you please reply

  • @nadeemkhalid2936
    @nadeemkhalid2936 3 ปีที่แล้ว

    Hi, Sumit sir,
    please make a video for excel VBA example if we show result between two dates like a customer ledger how we get the previous sum balance on the top of a specific cell
    Like if we make a date range from date 1/1/21 to 31/3/21 then we got only the desired range sum but if the customer has some old transactions like the customer starts transactions from 1/11/2021 then how can we get the old debit credit sum balance on the top of the statement like Banks Do.

  • @wongpeggy4363
    @wongpeggy4363 3 ปีที่แล้ว

    Hi. Hmm.if I want to sum multiple worksheet by text how?

  • @samirkumarsah8884
    @samirkumarsah8884 3 ปีที่แล้ว

    Sir
    I m a Insurance professional and want to make premium calculator with help of Excel Userform.
    Calculator have some input field and some output field. Pls help me on this if possible.

  • @dwacon123
    @dwacon123 2 ปีที่แล้ว

    How can we calculate running total percentage with a filter function

  • @coolag74
    @coolag74 3 ปีที่แล้ว

    👍👍👍

  • @baqeraliakbar
    @baqeraliakbar 3 ปีที่แล้ว

    I have 365 excel..
    I can not apply the running total in pivot

  • @akshaysharma_296
    @akshaysharma_296 3 ปีที่แล้ว

    Sumit sir,May I have your email id?

  • @DEATH_RACER_001
    @DEATH_RACER_001 3 ปีที่แล้ว

    Aap log ko hindi se kya dusmani hai ,

  • @xrysofficial
    @xrysofficial 3 ปีที่แล้ว

    hello ur computer has a virus

  • @akgjeevraj
    @akgjeevraj 3 ปีที่แล้ว

    VOICE IS EXTREMLY LOW