COUNTIFS metric referencing another sheet with multiple columns and drop down criteria

Dana S

I need help trying to return a count in a metric sheet be referencing one column that has one of 3 criteria, and an additional column has 1 criteria met. My current formula is:

=COUNTIFS({LRDC Status}, OR(CONTAINS("Acquisitions"@cell), CONTAINS("Construction", @cell), CONTAINS("Implementation",@cell)), COUNTIFS({Target Population}, "Medicaid")))

Any help would be appreciated.

Emilio Wright

@Dana S

When using an OR inside a COUNTIF you will need to use it in this manner:

=COUNTIFS({LRDC Status}, OR(@cell = "Acquisitions", @cell = "Construction", @cell = "Implementation"),{Target Population}, "Medicaid")

Emilio Wright

@Dana S

When using an OR inside a COUNTIF you will need to use it in this manner:

=COUNTIFS({LRDC Status}, OR(@cell = "Acquisitions", @cell = "Construction", @cell = "Implementation"),{Target Population}, "Medicaid")

Dana S

I was so close. That worked. Thank you for your help!