If cell range contains specific text then....

[intex]

Hi guys,
I'm stuck a bit, maybe somebody can give me a hand. This is what i would like to achieve:
if at least one cell in range G9:G18 contains "In Progress" G8="In Progress", if any cell in range G9:G18 do not contain "In Progress" (it will contain "Completed") G8="Completed"

Thanks in advance

[TMS]

Use COUNTIF to check the range for "In Progress". If the count is >=1 ... "In Progress"


Regards, TMS

[FDibbins]

Maybe this...

=IF(countif(G9:G18,"In Progress")>0,"In Progress","Completed")

or just this...
=IF(COUNTIF(G9:G18,"In Progress"),"In Progress","Completed")

[intex]

Hi FDibbins,

Thanks it works like a charm.

[FDibbins]

happy to help