Counting empty cells

[marystewart78]

Hi All,

I've been using the following function to create summaries in reports - where "criteria" is changed to match the item being counted.

=Abs(Sum([Status]="criteria"))

This has been working fine until I tried to use it to count empty cells - I've tried changing the criteria to NULL (without ") and "" but neither count the empty cells.

Any suggestions?

Thanks,

Mary

 

[ajetrumpet]

Mary,

NULL has no value, therefore you cannot perform a mathematical function on it. If you want a Count of all NULL cells in a field, use..."DCOUNT"