Works GREAT....thank you for your help

"JE McGimpsey" wrote:

Change 3 to 1

In article ,
ferde wrote:

Thank you for the reply but this formula will place a name in column A when
only one cell is empty. I only want an answer in b2 if all the cells in
the range C2:E2 are ALL empty . I'm sorry ... I probably wasnt clear.