I want to not count something

[Guest]

I have a report with columns. At the bottom of each column is a count feature
which counts the number of expressions in that column. =Count([Expr2])

Now I want to modify it so that if Expr2 is "SampleText" then it won't count
that. How do I do this?

 

[Rick Brandt]

I have a report with columns. At the bottom of each column is a count
feature which counts the number of expressions in that column.
=Count([Expr2])

Now I want to modify it so that if Expr2 is "SampleText" then it
won't count that. How do I do this?

=Sum(IIf([Expr2]="SampleText",0,1))