If Statement Help Please. Work result being returned

[Mechjo16]

if statement fix.xlsx

Hi all.

I hope someone can help.

I am trying to return a value open or closed in a cell depending on if a item is completed or not. The problem is I want the task to be "closed" if all the cells in the range contain completed or N/A. I can only get the formula to work if all the cells say "Completed"

Can anyone help me get the cell to read "Closed" when seeing "Completed" or "N/A"



Attached Example (C3 should say completed because card 1 through card 4 is either completed or N/A). C4 and C5 are working correctly.

1st line has attachment

[Richard Buttrey]

Perhaps

=IF((COUNTIF(E3:H3,"*Completed*")+COUNTIF(E3:H3,"N/A"))=4,"Completed","Open")

[Mechjo16]

This site is a lifesaver as are you. THanks!