View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Boolean Values in Pivot Table

I have a pivot table feed off a table 2 column talbe with booleans in teh
second column. I want te count the TRUE occurences. However the Count
property of the Field is counting both TRUE and FALSE answers. How do I only
count the TRUES?

OR do I have to use a COUNTIF in a manually created table?

Thanks

EM