COUNTIIF Problems

[Graham T]

In a report I am attempting to enter the following expression into the report footer to count the number of results containing YES/NO in the field [Agree with Decision].

At present I have used two text boxes containing:

=Count(IIf([Agree with Decision],"YES"))

=Count(IIf([Agree with Decision],"NO"))

However both are returning the same result, whereas I know that they both contain a different amount of results.

Anyone be able to shed any light on this query?

Thanks

Graham

 

[Rich]

Change it to =Sum(IIf([YourField]=Yes,1,0))

 

[Graham T]

Thanks Rich

The calculations are now working fine.

My problem now is how to use the results of these calculations to gain an overall total for all matches of Yes/No.

If I have the three calculations shown below:

=Sum(IIf([Agree with Decision]=Yes,1,0))

=Sum(IIf([Customer Contact]=Yes,1,0))

=Sum(IIf([Systems Updated]=Yes,1,0))

I would then like to total these, is this possible?

Thanks in advance

Graham

 

[Graham T]

No Problem, sorted now....my mistake