Forum Discussion
Matt_Husted
Jun 12, 2023Copper Contributor
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 ...
- Jun 12, 2023
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.
HansVogelaar
Jun 12, 2023MVP
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.
Matt_Husted
Jun 12, 2023Copper Contributor
Such a simple solution to a problem I have had for a couple months now. I truly appreciate the help.