For the %Turnover the calculation will be:
(Turnover/Total for group) * 100 - for each record within the Group(Branch).
Branch is in Column B
The %Turnover - will be in column I.
The totals follow the row immediately after the last Branch for the group - as above.
Using totals in the same column as data tends to not work for these kinds of projects.
If you need to see the totals for each one, then you can use the following formula in Column J, let's say first data starts at row 4, and Column B has Branch name, Column C has Account Number in, Column D has the branch totals.
Then in J4 put this formula:
and in I4 put this formula
Copy these two formulas down as far as your data.
If you don't need to see the totals for the branch totals, then in Column I just put this:
=D4/SUMIF(B:B,B4,D: D )
NOTE: If you copy these formulas, realize that I put a space after the : and before the D becazuse it converts to smilies).
old, slow, and confused
but at least I'm inconsistent!