COUNTIF As Pivot Calculated Field

[JADownie]

Hi -

I am trying to add a calculated field now to my pivot which will essentially output for me the # of rows in my data where the value for # slides in body of report is less than 35.

I tried using a COUNTIF formula, but I keep getting an error stating TOO FEW. Not quite sure what that means, or if this can even be done in a Pivot table now.

=COUNTIF( '# slides in body of report'<35)

Thanks for any advice here now.

 

[RoryA]

You can't use COUNTIF in a calculated field, I'm afraid.