Cell B2 = 27.001.008 (27 Karton 1 Lusin 8 Pcs)
Cell B3 = 58.002.120 (58 Karon 2 Lusin 120 pcs)
Array Function
=SUM(VALUE(LEFT(B2:B3,(SEARCH(".",B2:B3)-1))))Nuruddin Indonesia, Tab-Kar-Upg wrote:
Dear Teman2, Bisa bantu Rumusnya gak?27.001.008 (27 Karton 1 Lusin 8 Pcs)58.002.120 (58 Karon 2 Lusin 120 pcs) 85 Karton (Hasil)bantu rumusnya yach, cuman mau ngambil jml kartonnya aja. thanks,iKa
jumlah_karton.xls
Description: MS-Excel spreadsheet
