Trouble with formula, Excel 2007

[Purple_Girl]

Hello,

Would anyone be able to help me figure out a formula that I am stumped on? Basically, I've got a table of data that has Names, Total # Errors (for each name), and Categories (this is the "type" of error for each error listed).

My job is to find the Quality % for each person and for each Category. Which means, for each name, I have 1.) find out how many (the "count" - not sum) of Total Errors they have, and 2.) find out how many of those errors were made in which Category. From there, I can do a simple formula to calculate their Quality % for each Category. The challenging part, for me, is finding out what formula I need to use to find the 1. and 2. listed above.

Do you think you would be able to figure out a formula for me to use? Here's a sample of the table that I'm working on...

http://tinypic.com/r/j5jfv5/7

Please let me know if you can help!
Thanks SO much!!
Gina

 

[bkissick]

Hello,

Would anyone be able to help me figure out a formula that I am stumped on? Basically, I've got a table of data that has Names, Total # Errors (for each name), and Categories (this is the "type" of error for each error listed).

My job is to find the Quality % for each person and for each Category. Which means, for each name, I have 1.) find out how many (the "count" - not sum) of Total Errors they have, and 2.) find out how many of those errors were made in which Category. From there, I can do a simple formula to calculate their Quality % for each Category. The challenging part, for me, is finding out what formula I need to use to find the 1. and 2. listed above.

Do you think you would be able to figure out a formula for me to use? Here's a sample of the table that I'm working on...

http://tinypic.com/r/j5jfv5/7

Please let me know if you can help!
Thanks SO much!!
Gina

Sounds like a job for a pivot table... check out the MS articles on pivot tables and see if that helps.

 

[Purple_Girl]

Thank you...I will check out the board. I guess I would have to use multiple pivot tables, is that right?

 

[bkissick]

Thank you...I will check out the board. I guess I would have to use multiple pivot tables, is that right?

Should be able to get by with just one, bearing in mind I haven't seen your data. You can set up a pivot table field to do simple calculations on data, such as percentage, average, etc. in addition to a count.

 

[Purple_Girl]

Thanks for your response! CAn you view this link?

http://tinypic.com/r/2lia73m/7

It shows that data that I've got...