Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cumulative Percentage
Danny has attended:
Excel Intermediate course
Hi,
What is a nifty formula to produce cumulative percentages?
Thanks,
Danny
Hi Danny,
Thank you for your question.
I have attached a spreadsheet with a possible solution in column c.
I hope this helps.
Regards
Simon
Mon 9 Jul 2012: Automatically marked as resolved.
If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:
=SUM(C10:C25)
However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.
To get around this you can sum all the values in a column using the following formula:
=SUM(COLUMN:COLUMN)
Which, in our example, would be:
=SUM(C:C)
NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.
The formula must be placed in any other column, EXCEPT the one being calculated.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
cumulative percentages.xls