Forum Discussion
Solved
Counting Letters in a column
Hi all,
I have a column that asks "Tax Exempt?". The response is Y or N. I would like to count how many Ys are in that column and have that total appear in another cell. Here is a picture:
I thank you for your time.
Assuming you have that set up as an Excel table, this will work: =COUNTIF(Table1[Tax Exempt],"Y")
If it's not an Excel table, then =COUNTIF(K3:K11,"Y") and you'd need to adjust the range as your data adds more rows
Here's a useful reference to the COUNTIF function.
1 Reply
Assuming you have that set up as an Excel table, this will work: =COUNTIF(Table1[Tax Exempt],"Y")
If it's not an Excel table, then =COUNTIF(K3:K11,"Y") and you'd need to adjust the range as your data adds more rows
Here's a useful reference to the COUNTIF function.