COUNTIF / Collect formula

nmahy

Hey guys I am stumped. I am trying to Count the number of cells in my Company column if the company = "the company name" but only if one or more of the cells in Column G:T has the words "Needs Replaced"

Multiple columns in G:T could have the words "Need replaced" But I only need to count the company name once if that makes any since

BullandKhmer

Helper Column

=IF(OR(CONTAINS("Needs Replaced",G@row),CONTAINS("Needs Replaced",H@row) …. ,CONTAINS("Needs Replaced",T@row)),1)

Metric Sheet

=COUNTIFS({Company Name},[Company Name]@row, {Helper Column},1)