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
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