Forum Discussion
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 c...
=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?