sumif null is counting all records (1 Viewer)

[Djblois]

I am using a sum(if()) to count all the records in a subform that are null and it is couting all the records? What am I doing wrong?

Here is the formula I am using:

=Count(IIf([ReturnTime] Is Null,1,0))

and I tried

=Count(IIF(IsNull([ReturnTime],1,0))

and

=Count(IIf(IsEmpty([ReturnTime]),1,0))

 

[Djblois]

I figured it out if anyone is looking for this


=Sum(IIF(IsNull([ReturnTime],1,0))