Try this

=IF(COUNTA(D1:I1)=0,"X","")

Mike

"Jim" wrote:

Hello,

I have about 5k lines of data. Columns A, B and C all have data. D, E, F,
G, H and I may or may not have data. In K I would like to have a formula
that would read D, E, F, G, H and I and if they are all blank I would like
for K to return a X.

Thanks in advance for the help.
Jim