Excel formula to calculate percentage completion

[collinsc]

Hi
I would appreciate some help to create a formula...

I want to use the Y and N in Col B to calculate 2 totals...
1) How many are complete (as per Row 5) e.g. 2 of 4 = Y
2) The perecentage of the above calculation (as per row 6)

ColA ColB
Row 1 Item 1 Y
Row 2 Item 2 N
Row 3 Item 3 N
Row 4 Item 4 Y
Row 5 Total 2/4
Row 6 % 50%

Many thanks

 

[etaf]

=Countif(B1:B4,"Y")/((Countif(B1:B4,"Y")+Countif(B1:B4,"N"))
will give the Percent Y against all rows with a Y or N

=Countif(B1:B4,"Y")&" / "&((Countif(B1:B4,"Y")+Countif(B1:B4,"N"))&" = Y"
will give the text
2 of 4 = Y

 

[collinsc]

thanks so much

 

[etaf]

you are welcome