ExcelBanter - Pivot Table Counting

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pivot Table Counting (https://www.excelbanter.com/excel-worksheet-functions/188705-pivot-table-counting.html)

Newbee

Pivot Table Counting

I have a row of yes and no answers. How do I count only the yes answers in a
pivot table?

ND Pard

Pivot Table Counting

Look up HELP on the function: CountIf. I think it'll give you what you want.

"Newbee" wrote:

I have a row of yes and no answers. How do I count only the yes answers in a
pivot table?

All times are GMT +1. The time now is 01:22 AM.