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
reports that are given to accounts to represent the status of our
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
Column B ColumnC
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