Forum Discussion
Solved
Creating a tally
I have a log that I would like to create a tally for. Column P has Ys and Ns. I would like to create a tally in columns Q and R for the total Ys and Ns respectively but I am unable to properly build a formula that works.
In Q2:
=COUNTIF(P:P,"Y")
In R2:
=COUNTIF(P:P,"N")
Alternatively, create a pivot table based on column P, and add the fieldname of column P to both the Columns area and the Values area.
2 Replies
In Q2:
=COUNTIF(P:P,"Y")
In R2:
=COUNTIF(P:P,"N")
Alternatively, create a pivot table based on column P, and add the fieldname of column P to both the Columns area and the Values area.
- Such a simple solution to a problem I have had for a couple months now. I truly appreciate the help.
