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 ...
Without modern functions
=SUM( FILTERXML("<t><s>"&SUBSTITUTE(B3,CHAR(10),"</s><s>")&"</s></t>", "//s") )