SOLVED

Count on pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-2770481%22%20slang%3D%22en-US%22%3ECount%20on%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2770481%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20count%20the%20number%20of%20%22YES%22s%20in%20a%20column%20on%20one%20sheet%2C%20and%20display%20the%20total%20on%20my%20pivot%20table.%20I%20can%20do%20count%20(but%20that%20just%20displays%20the%20total%20number%20of%20answers%2C%20regardless%20of%20them%20being%20YES%20or%20NO)%2C%20and%20Distinct%20(but%20that%20displays%202%2C%20I%20assume%20for%20yes%20and%20no).%20In%20regular%20spreadsheets%20I%20could%20do%20countif%20(%3DYes)%20but%20can%20you%20do%20that%20on%20pivot%20tables%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2770481%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2770728%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20on%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2770728%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1162282%22%20target%3D%22_blank%22%3E%40Aceplante%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20the%20pivot%20table%20contains%20only%20the%20field%20with%20YES%2FNO.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2771783%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20on%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2771783%22%20slang%3D%22en-US%22%3E%3F%3F%3F%20so%20how%20do%20i%20count%20and%20tally%20up%20the%20number%20of%20yes's%3F%3C%2FLINGO-BODY%3E
New Contributor

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

@Aceplante 

Yes, the pivot table contains only the field with YES/NO.

 

??? so how do i count and tally up the number of yes's?
best response confirmed by Aceplante (New Contributor)
Solution

@Aceplante 

Drag the field in the rows area and in the values area.