SOLVED

# Help with Formula to get Sum of Non-Numerical Column

Copper Contributor

# 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?

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: Help with Formula to get Sum of Non-Numerical Column

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

# Re: Help with Formula to get Sum of Non-Numerical Column

Hi Joe,

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

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: Help with Formula to get Sum of Non-Numerical Column

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