Running Count with Specific Criteria

TianaJones

Hello!

I have a spreadsheet with different projects and their statuses. I'd like to make a running count of projects with certain statuses indicating they're still open (there are statuses indicating they're closed). I'd like to show a running count of how many open projects there are.

There are six statuses indicating they're open (for each step of the process: "Vendor", "CA QC", "Study Team", "Pricing", "Department", and "Pending Sign-Off")

I have an auto-number column but that counts every project regardless of status and I can't figure out how to count just the open ones!

Thanks!

heyjay

Can you try this:

=COUNTIF(Status:Status, CONTAINS(@cell, "vendor ca qc study team pricing department pending sign-off"))