Need to calculate percent from multiple criteria

[Jan]

I need help to write a complex formula and would greatly appreciate
help from an Excel expert.

I have several worksheets setup for each account; these worksheets are
a report that is given to the account to represent the status of our
service.

I also have 2 other worksheets (which are lists) to enter account data
regarding our service.
Sheet 1 contains 1 row of data per account.
Sheet 2 contains issues for accounts and may contain 1 to many rows
for an account.

Account worksheet: The Account Name, Account # are in cells a1 and
a2, respectively. In column C, rows 10 thru 15, I need to calculate
the percent which must be a result of 100 divided by total issues
(count) for the account (entered on sheet1 column C) * the number of
specific issues (count) for that category (entered on sheet 2, column
F) for each item in b10 thru b15. The following is an example of what
I need to achieve for an account that has a total count of 5 issues.
Issue_1 is listed once, Issue_2 is listed 3 times and Issue_4 is
listed once.
Column B ColumnC
Issue_1 20%
Issue_2 60%
Issue_3 0%
Issue_4 20%

Sheet 1 contains 1 row for each account and the account # is in column
B and the count of all issues for the account is in column C.
Sheet 2 may contain 1 to many rows for an account. The account # is in
column B. Column C stores an issue, which is the reason for 1 to many
rows. The issues that may be entered are 1, 2, 3, and 4; it is
possible for any issue to be repeated in another row.

Is it possible to enter a formula to achieve the results for Issues?

TIA
Jan

 

[Ian digby]

Jan,
Have sent a solution.
Ian Digby