I’ve read through all the Count-related posts and guides, as well as feature requests for COUNTIF, but am unable to solve a simple problem – and feel there must be a solution. So:
Table 1 (Projects) lists Projects in Column A.
Projects have several statuses (Active, Cancelled, Closed, etc.) in Column B.
Each Project has several People assigned to them in Column C.
Table 2 is linked to the People column in Table 1.
Column B in Table 2 Counts the number of Projects assigned to each person.
The Count however counts ALL projects, whatever their status.
How can I count, in Table 2 (Persons), just their ACTIVE Projects, from Table 1?
Any help would be much appreciated!