Pak Imry;

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




Wassalam


~ Bagus ~






  ----- Original Message -----
  From: imry yahya [email protected] [XL-mania]
  To: [email protected]
  Sent: Friday, June 13, 2014 2:54 PM
  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


  

Kirim email ke