Accumulative formulas

Resolved · Low Priority · Version 2013

Thu 23 Jul 2015, 16:51 Delegate Elizabeth said...

Elizabeth has attended:
Excel Intermediate course

Accumulative formulas

Fri 24 Jul 2015, 11:28 Trainer Jens said...

RE: accumulative formulas

Hi Elizabeth,

Thank you for the forum question.

You can use many formulas/functions in Excel to get accumulative total. The sum function can give a accumulative sum. I have created and example in the attached workbook.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Attached files...

Accumulative sum.xlsx

Fri 31 Jul 2015: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips