Help with Formula to get Sum of Non-Numerical Column

New Contributor

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 Replies
best response confirmed by Hans Vogelaar (MVP)



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")

Hi Joe,

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