Dear Pak Gunawan, mungkin bisa coba pakai =subtotal(109;selawal:selakhir) contoh: =subtotal(109;a1:a100) thanks
Hormat saya, Felix ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of fransescoc Sent: 30 Juni 2008 10:41 To: [email protected] Subject: ]] XL-mania [[ tanya cara menjumlah kolom yang disembunyikan hi rekan2 para master excel, tolong bantuin ya, saya ada sedikit kesulitan nih, contoh kasus: A1 100 A2 200 (hide rows) A3 500 A4 250 kita ingin menjumlahkan keseluruhan dari A1:A4; namun karena A2 di-hide; maka jumlah akhirnya 850; terima kasih, Salam; Gunawan _____________________________________________________________________ This message has been checked for all known viruses by the MessageLabs Virus Scanning Service. For further information visit http://www.messagelabs.com/stats.asp CONFIDENTIALITY NOTICE: This communication (which term shall include any attachments) contains information which is confidential and proprietary in nature and the copyright in which belongs to Zuellig Pharma Asia Pacific or a subsidiary of Zuellig Pharma Asia Pacific (hereafter referred to jointly and singularly as Zuellig Pharma) or a third party. This communication is intended solely for the individual to whom it is addressed. If you are not the intended recipient of this communication, you may not disseminate, distribute, copy or otherwise disclose or use the contents of this communication without the written authority of Zuellig Pharma. If you have received this communication in error, please delete and destroy all copies and kindly notify the sender by return email or telephone immediately. Thank you. Zuellig Pharma makes no representations or warranties in respect of the integrity of this communication, including but not limited to any warranty that this communication is free of errors, viruses or other malicious code, interception or interference. _______________________________________________________________________ This message has been checked for all known viruses by the MessageLabs Virus Scanning Service. For further information, visit http:\\www.messagelabs.com\stats.asp
