Multiple cells contain same TEXT

[arshadbh]

[/IMG]

Kindly help me, I'm looking for a formula if multiple cells (D54 to D61) contain the same text (Closed) D53 should show as Closed if one of the columns (D54 to 61) has a value other than Closed (Such as pending or in progress) D53 should show "pending"

 

[Joe4]

Re: Multiple cells contain same TEXT - Kindly help

Try:

=IF(COUNTIF(D54:D61,"Closed")=8,"Closed","Pending")

 

[arshadbh]

Re: Multiple cells contain same TEXT - Kindly help

Thank you for your help and time, much appreciated.

 

[Joe4]

Re: Multiple cells contain same TEXT - Kindly help

You are welcome!