Counting Active Projects

sophiaashepard

Hey!

I am wanting to count the number of projects in each department (e.g., Health Action) that are marked as active. I am currently using this formula where I manually enter how many inactive project to subtract from the total but I would like to have this imbedded in a formula so it updates automatically. Thank you!

Kelly P.

@sophiaashepard Maybe I'm not understanding what you're trying to accomplish, but couldn't you just put this formula in row 1 of the "Active Project/Staff" column?

=COUNTIF([Active Project/Staff]:[Active Project/Staff], "Active")

Hope this helps!