Skip to main content

Running Total/ Cumulative Sum in Excel

 

Hey Guys! You should have noticed that I'm writing on MS Excel for last few days! To be honest I'm trying to learn some simple and useful tricks of Excel. And I'm also trying to share my knowledge with you. In this post I've come with such a little trick which maybe very useful if you face such situation. Let's begin . . . 

 

Running Total/ Cumulative Sum

It means the summation of numbers in a list and it will be updated each time when a number is added or changes. Look at the image below - 

 


Look at the image. There are two columns with numbers. The first one is simply the number list. But the 2nd one is the summation of the list. Each time a new number is added to the first column the second one shows the summation.


How to do this? 

It's not a magic. Very simple sum formula is used to perform this task. But there is a little trick. You just need to lock the first cell and then every time it will update the running total list. 


Here is my list. Simply type some numbers in your Excel. In my list there are 10 numbers ranging from F7 to F16. And I've used column G for running total calculation. In G7 I've used this formula - 

 =SUM($F$7:F7)

Or this will work too  =SUM(F$7:F7)

Why $ sign? Yes that's the magic. In Excel $ sign is used to lock a cell. In G7 this formula will add F7 with F7 itself. But in G8 this formula will add F7 with F8. In G9 this formula will add F7, F8 and F9. 

Know why? Cause you've locked first F7 cell by putting dollar sign. But the second F7 is not fixed. When you drag the formula the first F7 cell will remain in its position and the second F7 cell will be converted to F8, F9, F10 . . . .


How do you put $ sign

You can lock the cell manually by simply typing dollar sign. But there is a comfortable keyboard shortcut you can use. This is F4. Put your cursor in the formula. Place it before the cell number which you wanna lock. Now press F4 button to automatically put the dollar sign. Do this like - 

=SUM(IF7:F7)

Look at the red sign in the above formula. Suppose it's your cursor. Take your cursor at this position and press F4. And it will lock your first F7 cell like below - 


=SUM($F$7:F7)

If you type manually then you don't need to put $ before F. You can just put $ before 7. This will do the same task. 


Project File (Running Total/ Cumulative Sum

 

You can also download the project file from the above link. 


Hopefully this will help you in your work. Feel free to contact us if you face any problem regarding this tutorial. And obviously thanks for visiting Marks PC Solution . . .


Comments

Popular posts from this blog

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them.  To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs.  I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side.  You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom.  Effect Cheat Code Adrenaline Mode MUNASEF All Cars Explode ALL...

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!! About the Activator   Name: KMSPico 10.1.5 File Size: 3 MB (Approx) File Type: Zipped Folder 100% Neat & Clean - No virus! Activating Capacity . . . KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010 Windows 10, 8.1 & 8 Hopefully this version will work for both 32 bit & 64 bit versions of Windows. Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else. Install it as trial version without any key. Use the follow...

Rules for Bengali Typing in PDF (Bijoy Layout)

Bijoy is the most popular layout for Bangla typing. The layout was developed by Mostafa Jabbar. He is the pioneer of Bangla typing in computer. More than 90% people use his Bijoy layout for Bangla typing. Today, I'm gonna share a PDF file with you that contains the Bijoy Keyboard layout with English fonts! If your keyboard doesn't have bengali fonts then you can print this PDF file to know where the bengali fonts are located in your keyboard. Additionally this file contains all the necessary rules and tips which are essential for Bangla Typing.  Now there are many other software available for Bangla Typing Layout. Such as Avro Easy, Unicode, Unibijoy etc. And there rules are also somewhat different from Bijoy. And some of their layouts follow the same rules like Bijoy. Hopefully this PDF file will support most of the rules when a layout is similar to Bijoy Layout.  Click to enlarge the image Download the PDF file from the button below. Follow...