Selamat siang, mungkin rumus ini bisa membantu
=SUMIF(D1:D22,"<>#DIV/0!") Terimakasih, Aris Nurcahyo ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of andreas_harefa Sent: Wednesday, August 27, 2008 12:37 PM To: [email protected] Subject: ]] XL-mania [[ Penjumlahan dengan cell yang terisi #DIV0 Pada para Expert, mohon bantuan dunk, apa bisa jumlah nilai range cell Misal =SUM (D1:D22), tapi salah satu/ beberapa cell isinya #DIV0, nah supaua hasilnya tidak #DIV0, bisa ga???? BAGAIMANA CARANYA kah? salam Andreas Important: The information contained in this email is confidential and may be legally privileged. It is also subject to copyright. If you have received it in error, confidentiality and privilege are not waived and you must not disclose or use the information in it. Please notify the sender by return email and delete it from your system. Any unauthorised use is expressly prohibited. Please consider the environment before printing this e-mail.
