Returning a percentage after a count

[Yusuf]

Hi all

I'm trying to create a percentage of items by it's status at the time.

Eg;
Col A has the item Name and a Total or each item Name as in a pivot table
Col B has the item status, either Good or Bad

A2 to A9 = Apple
A10 = Apple Total
A11 to A15 = Pear

B2 to B9 = 5 Good and 3 Bad
B11 to B15 = 3 Good and 2 Bad

I need the formulas in Col C (only beside the Totals) to return a percentage of Good items according to the number of items but not count the fruit before/above and it's status.

My apologies if this is unclear but I've been thinking of better ways of writing it and hope this is the best.

 

[Aladin Akyurek]

Hard to imagine why you opt for such a fragile kind of data representation...

Book2
	A	B	C	D
1	Item	Status
2	Apple	Good
3	Apple	Bad
4	Apple	Good
5	Apple	Good
6	Apple	Good
7	Apple	Bad
8	Apple	Good
9	Apple	Bad
10	8	0.625
11	Pear	Good
12	Pear	Bad
13	Pear	Bad
14	Pear	Good
15	Pear	Good
16	5	0.6
Sheet1

A10:

=COUNTIF(A2:A9,"Apple")

B10:

=COUNTIF(B2:B9,"Good")/A10

Formulas are similar in A16 and B16.

 

[Yusuf]

My sincere apologies

In my example I stated the ranges but at the moment I've been given 12000 rows of data and the item totals are very different.

I put a formula in Col C (C2) to get a total of the items that reads;
=IF(A2=A1&" Total",countif(A1:A2,A2),"")

In C10 I get a total count of the Apples and C16 for the Pears

Is there a formula I can enter in Col D that takes this Total into account and be devided by the number of "Good"?