Counting a report column that doesnt have formatting

[mcmcd99]

So I'm trying to count up a column like this to get some data on how many of each type are in the records of the particular report. This doesn't seem to be giving me a total of only the records with the type of ARFF, but simply a count of all records on the report. How do I specify ARFF only?



=Count([type]="ARFF")

[mcmcd99]

I've also tried:

=Count( Iif(Not [type]="military",[type],Is Null) And Iif([type]="military",[type],"*") )
and
=Sum( Iif(Not [type]="military",[type],0) And Iif([type]="military",[type],"1") )

but no luck. And the sum one is just returning a negative number.

[ArviLaanemets]

=DCount("type","YourTable","type = 'ARFF'")