Filtering a Count field


Is it possible to filter the results that are counted in a Count field? Example: “Tasks” table is a list of tasks, with a single select column ‘Stage’ that has values representing what stage of completion a Task is in and a ‘Facilities’ column representing buildings. A second table, “Facilities”, is linked and I want to count the number of tasks for each facility but exclude anything with a ‘Stage’ value of Complete.


You can add an additional formula field that is filled only when the stage is not equal to ‘Complete’. Then use that field for counting in your other table…