Dear all ,I want you help to get sum for cell numbers combined with text in a multiple lines cell
and i have this formula work in cell multiple Lines but without Text .... I Mean Just For Number
if any one can to help me to change this formula to work for Numbers with Text in Column B ....and thanks alot ,with my Best Regards
and i have this formula work in cell multiple Lines but without Text .... I Mean Just For Number
Code:
=SUMPRODUCT(IFERROR(MID(SUBSTITUTE(b2,CHAR(10),REPT(" ",30)),{1;30;60;90;120;150},30),0))
Attachments

11.5 KB Views: 4

9.4 KB Views: 5