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