Help with Formula to get Sum of Non-Numerical Column

[kfish1000]

I have a column filled with either Y's or N's, I only want a total count of all the N's for this column.  What formula do I use? 

[#2 · Accepted solution]

@kfish1000 

It's not a "sum".  It is a count, as you note in your description.

Your posting lacks sufficient details for a turnkey solution.  Perhaps something of the form:

=COUNTIF(A1:A100, "n")

[#3]

Hi Joe,

Sorry I was not clearer on my question, but you understood my thought and your formula worked.
Thank you