multiline cell: sum the second line of each cell

I need to sum the second line of every cell from a range.

• Every line is separated by char(10)
• Some cells doesn’t have 1st, 2nd or 3rd line

I’ve tried to split and index 2nd row, I’m capable for 1 cell but not for the entire range.

>Solution :

You can try with this formula that SPLITs the values by CHAR(10), with INDEX grabs the second value. With BYCOL repeats the process for each of the three columns. SUMs them, and finally repeats the process for each row with BYROW:

=BYROW(B2:D,LAMBDA(r,IF(COUNTA(r)=0,,
SUM(BYCOL(r,LAMBDA(each,INDEX(SPLIT(each,CHAR(10),1,0),,2)))))))