Forum Discussion
Solved
Count on pivot table
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?
3 Replies
- ??? so how do i count and tally up the number of yes's?
