Forum Discussion

Matt_Husted's avatar
Matt_Husted
Copper Contributor
Jun 12, 2023
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 ...
  • HansVogelaar's avatar
    Jun 12, 2023

    Matt_Husted 

    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.

Resources