SOLVED

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

Hi Joe,

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