How to calculate count in one column while considering parameters/criteria from other columns?

Emily Halley

I'm looking to see the number of projects in each status bucket - completed, in progress, not started - but only for certain criteria.

First, I only want to count the statuses for projects with a start date after 4/1/2025 (listed in the Sponsorship Start Date Column).

Second, I only want to count the statuses for projects tied to the following groups: Endoscopy, IPS. This will need to be a "contains formula" as some cells include Endoscopy and Surgical Endoscopy. I want to include them whether they are standalone or combined.

Any suggestions on the formula I'd use to achieve this? Thank you!

Paul Newcome

You would use a COUNTIFS. A COUNTIFS with a CONTAINS looks like this:

=COUNTIFS({Range}, CONTAINS("Endoscopy", @cell))