Forum Discussion
Solved
Help with Formula to get Sum of Non-Numerical Column
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?
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")
2 Replies
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
