Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jan
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XML / parent with multiple children and with multiple children Richard Excel Discussion (Misc queries) 0 January 5th 05 12:49 PM
Counting rows based on criteria in multiple cells Margaret Excel Discussion (Misc queries) 11 December 3rd 04 12:04 AM
calculate percent increase vlro Excel Discussion (Misc queries) 1 December 1st 04 03:35 PM
Multiple Vlookup? changeable Excel Worksheet Functions 0 November 9th 04 12:52 PM
Count rows based on multiple criteria Murph Excel Worksheet Functions 1 October 28th 04 07:13 AM


All times are GMT +1. The time now is 03:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"