Selected Answer

Hi Geoffery

The profit or loss is amount ($ in your case) the share value moves from the "original" value.

The percentage profit or loss is that movement divided by the original value of a given individual share (or grouping of shares). You can add individual profit or loss ($) values to combine them into an overall profit or loss but you can't just add the individual percentage profit or loss values.

To calculate the overall percentage, you need to divide the sums of the individual profit or loss ($) values by the sum of the **original** values (which you seem to refer to as *Start Balances*).

Your current spreadsheet doesn't show what the original value so, in the attached revised file, I inserted (now) column C and labelled C5 as "*Original Start Balance (deduced)*". Pink cells calculate that original value usinng the formula (for D6) like:

`=100*D6/E6`

.

and likewise to row 9 and for rows 13:16.

(**Note**: that might not produce the exact amount,depending on the accuracy of your $ and % figures but you could overtype inexact numbers with the correct values).

Row 10 uses SUM calculations on the $ values in C and D to give the totals so the overall percentage is easily calculated (in blue cell D10) as:

`=100*D10/C10`

To get the combined percentage profit of loss, the yellow cells in rows 20:23 simply add the category values, e.g. for "*Balanced - Risk Adjusted*", D5 is just

`=C6+C13`

etc.

The same "blue cell" formula then works just the same. The grey cells E20:E23 calculate "category" percentages from the values in C20:D23.

Note that I didn't do anything with columns !:L (now hidden) or the chart.

Hope this makes sense and fixes your problem. If so. please remember to mark this Answer as Selected (or choose Willie's if that's better for you).