# Trouble with formula, Excel 2007

#### Purple_Girl

##### New Member
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

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

#### bkissick

##### New Member
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

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

#### bkissick

##### New Member
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.

Replies
0
Views
643
Replies
1
Views
387
Replies
3
Views
194
Replies
5
Views
265
Replies
2
Views
141

1,191,387
Messages
5,986,317
Members
440,017
Latest member
vasanrajeswaran

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back