how to count the total number of specific word in a column

count.JPG

From the picture I uploaded, there is two letters, ’Y’ and ‘N’ in column C. We can count there are total three ‘Y’s and four ‘N’. But instead of me counting them manually, I want to create a function that can

1) calculate the total number of ‘Y’s and total number of ‘N’s in column C.

2) The function must also be able update the total counts automatically if in future I makes changes in column C, e.g. changing cell C:3 from ‘Y’ to ‘N’.

You don't need to create one, Excel has one:

=COUNTIF(A1:A10,"*Y*")