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

In this video, I will show you different ways to calculate Running Totals in Excel.

The method you choose will depend on the data structure.

The following methods to calculate running total are covered in this video:
-- Using formulas in a tabular dataset
-- Using formulas in Excel Table
-- Using Power Query
-- In Pivot Tables

✅ Formula used in Power Query: List.Sum(List.Range(#"Added Index"[Sale],0,[Index]))

---------------------------------------------------------------------------------------------------------------------
00:00 Intro
00:15 Running Total using Formulas
02:01 Running Total Based on a Condition
04:10 Running Total in Excel Table
06:30 Running Total Using Power Query
10:14 Running Total in Pivot Table
---------------------------------------------------------------------------------------------------------------------

#Excel #ExcelTips #ExcelTutorial

[trumpexcel]

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:

[InsightfulJourney]

The best excel instructor ever on YouTube!!!

[jiajiaphotography]

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

[IvanCortinas_ES]

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

[kashmoney]

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

[patrickschardt]

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

[ripudamansingh]

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

[cadjiton]

Thank you Sumit, it's super easy

[Immortalsouls]

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

[khalidrehman]

Hi Sumit, nicely explained, thumbs up

[fayazmuhammad]

Thank you sir for sharing useful information

[CarlosMoreno-vwir]

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

[HusseinKorish]

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

[lucianapinheirofurquim]

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

[amitgurav]

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

[ripudamansingh]

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

[sanjaysrivastava]

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

[nawazsharifcollege]

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

[lalitchhaya]

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

[mushfiqulislam]

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