Two tables to feed into each other

Copper Contributor

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)

 

Thank you in advance

3 Replies

@Dee1234910 

=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.

 

@OliverScheurich Thank you- now :)

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?

@Dee1234910 

=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.

0.JPG1.JPGblank.JPGempty.JPG