Calculating Percentage values in a Subtotalled Table

I have a table of information that has subtotals inserted - example below:

Screenshot 1.JPG

I need a repeating formula or vba that will work out the percentage value of the Company's Total Credit Limit in each of the Company's individual entries.

i.e.

Screenshot 2.JPG

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this ONCE: https://www.mrexcel.com/board/thread...table.1241642/)

Please provide the workbook with some expected results and annotations added.

I squinted to read your screenshot.

Is this what you want?

=E2*VLOOKUP(A2&" Total",$A$2:$C$45,3,0)

Did you try my suggestion?

It is necessary to change the layout of the table slightly, because otherwise the formula and the values that the formula needs will interfere with each other and that is not possible in Excel.

Please insert between column C and D an extra column and try in D2 and copy down:

Formula:

Please Login or Register  to view this content.

and try in F2 and copy down:

Formula:

Please Login or Register  to view this content.

No need to change the layout with mine, assuming it's what the OP wants (they haven't responded yet).

Administrative Note

... please don't ignore contributors to your thread - it takes members time to provide suggestions, so acknowledge all solutions offered, even if they don't meet your requirements. Thanks.

Also, have you read and understood post #3? You need to acknowledge it.

You are Welcome. Thanks for the feedback and rep . Glad to have helped.

@Ali, you also changed the layout, because you added an extra column for the limits per account. That's the same layout change I applied.
And in my solution the percentages are also calculated based on the number of occurrences.

How was it meant to be done without adding a column? The annotations were in that column so that’s where I assumed they were meant to be. I don’t see adding a column as a change to the layout!

Anyway, the OP hasn’t even had the courtesy to acknowledge the help I offered, so I’m not really that bothered. I am glad they had the courtesy to thank you at least.