# Two tables to feed into each other

Please help with the formula, I would like cell J4 to either have a 1 or left blank- depending on whether another table having any data in the following cells. F52-M52. I don't want it to count the cells.

So J4 to have a 1 (if F52-M52) has any data in it, or J4 to stay blank if there is no data in (f52-M52)

J4 is the tracking of whether someone has attended a club

Where F52-M52 are the clubs that they could have attended)

3 Replies

# Re: Two tables to feed into each other

``=IF(SUM(LEN(F54:M54))=0,"",1)``

You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

# Re: Two tables to feed into each other

Same sort of thing... but

If Cells H79-K79 have a 1 (but not to add up just a symbol of data-like before) can that be transferred to R4 but... if the H79-k79 have a 0 that is transferred as a 0?

Hope that makes sense?

# Re: Two tables to feed into each other

``=IF(AND(SUM(N(LEN(H79:K79)))=1,SUM(H79:K79)=1),1,IF(AND(SUM(N(LEN(H79:K79)))=1,SUM(H79:K79)=0),0,""))``

Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.    