Dear Imry,

Coba dengan rumus sumif  =SUMIF(I6:I10,">0",I6:I10)

Salam,

Kus


From: [email protected] [mailto:[email protected]]
Sent: 13 Juni 2014 14:54
To: [email protected]
Subject: ]] XL-mania [[ SUM seluruh sell termasuk sell error [1 Attachment]


Dear Master XL,

tolong dibantu bagaimana menjumlah (SUM) seluruh sell dimana di antara cell ada 
cell error ?

Terima kasih
Imry

Attachment: Copy of Tanya XL .xls
Description: Copy of Tanya XL .xls

Kirim email ke