Forum Discussion
Formula question
I have a cell that contains 3 lines of numbers and I need to make sure all three numbers get included in a formula. Whenever I use the sum function, it does not include any of the numbers. How would ...
Is there a way around this, other than giving each number its own cell?
With Beta function TEXTSPLIT*
in B7:
=SUM(
BYROW(B1:B6,
LAMBDA(rw,
IF(ISTEXT(rw), SUM(--TEXTSPLIT(rw,CHAR(10))), rw)
)
)
)
* can be simulated