Sep 21 2021 07:28 AM
I am trying to count the number of "YES"s in a column on one sheet, and display the total on my pivot table. I can do count (but that just displays the total number of answers, regardless of them being YES or NO), and Distinct (but that displays 2, I assume for yes and no). In regular spreadsheets I could do countif (=Yes) but can you do that on pivot tables?
Sep 21 2021 08:08 AM
Sep 21 2021 01:01 PM
Sep 21 2021 01:25 PM
SolutionSep 21 2021 01:25 PM
Solution