View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ND Pard ND Pard is offline
external usenet poster
 
Posts: 73
Default 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?