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 https://support.microsoft.com/en-us/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7*
in B7:
=SUM(
BYROW(B1:B6,
LAMBDA(rw,
IF(ISTEXT(rw), SUM(--TEXTSPLIT(rw,CHAR(10))), rw)
)
)
)
* can be simulated