COUNTIF formula across multiple columns with same dropdown options

Galexa0711

I have a COUNTIF formula across multiple columns in a range from another sheet with same dropdown options:

Formula: =(COUNTIF({Pipeline Status Inputs - MPP Delivery Assu All Are}, (HAS(@cell, "DA Not started / On hold"))))

The result is giving me a count of every cell with the "DA Not started / On hold" selection but I need just the number of rows that contain the selection regardless of how many times in the row is appears.

I tried to change to @row instead of @cell but received an Unparseable error -

Formula: =(COUNTIF({Pipeline Status Inputs - MPP Delivery Assu All Are}, (HAS(@row, "DA Not started / On hold"))))

I would appreciate any assistance with this. Thanks!!

Gina Alexander

Business Analyst Consultant, Client Delivery Assurance | Optum Insight Provider Market

M 1-702-218-0919

[email protected]

OUR OPTUM360 VALUES

Integrity Compassion Relationships Innovation Performance

Eric Law

@Galexa0711 You have a lot of superfluous parenthesis. Try

=COUNTIF({Pipeline Status Inputs - MPP Delivery Assu All Are}, "DA Not started / On hold")