Hai pak Pukka, saya coba bantu ya, =EVALUATE("SUM({"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( TRIM(Sheet1!$A2);".";";");"#";"}^0)*");" ";"+SUM({")) pasang pada Name Manager (lihat gambar)
>semoga bermanfaat
Hai pak Pukka, saya coba bantu ya, =EVALUATE("SUM({"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( TRIM(Sheet1!$A2);".";";");"#";"}^0)*");" ";"+SUM({")) pasang pada Name Manager (lihat gambar)
>semoga bermanfaat