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