Set up a self join relationship that only matches to those records. Then either Count or a counting summary field can return the number of records.
Get ( accountName ) can be defined in an unstored calculation field to use as one match field.
a calculation field that returns "open" or whatever value marks a record as "open" can be set up as a second match field for this relationship.
ExecuteSQL can also be used to return this count.