Home |
Search |
Today's Posts |
#1
|
|||
|
|||
calculate percent from multiple criteria
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
calculate percent increase | Excel Discussion (Misc queries) | |||
Multiple Vlookup? | Excel Worksheet Functions | |||
Count rows based on multiple criteria | Excel Worksheet Functions |