Excel 2007 : Conditional Percentage

[Mo2783]

Hello

I need help I have a column with 8 options, select with a pick list. I am trying to Calculate a percentage for each criteria.

Eg

Col A

Row 1 N/A
Row 2 Cut
Row 3 Sew
Row 4 Sew

Sew 67%
Cut 33%

The above Example shows that sew is 67% and cut 33%. I want to ignore the N/A so hence the formula should be countif(a1:a4, "Sew")/(4-1) ignoring the N/A. The above is a sample set of data the list can be up to 20 long.

Please help

Mo