totals and pivot table

I would like to count the y , n and na at the bottom of each column.

can I use pivot tables to total the counts.

This is a sample file as the original is very large.

help would be much appreciated.

Regards Robert

not an expert or anything but heres wat i think

dont think you will be able to do it in a pivot as the data fields have to be numbers .. it wont read text..


you could just go use this under the columns

=Countif(C2:C10,"y")
=Countif(C2:C10,"n")
=Countif(C2:C10,"na")

hope that helps