Dear Para Pakar Excel, Mohon bantuannya,bagaimana formula/cara menjumlahkan agar pada kolom akhir yg muncul hanya angka yg negative/minus saja begitu juga kolom selanjutnya hanya angka postive saja.
sebagai bahan,saya kirim lampirannya. terima kasih untuk pencerahannya. salam Didin ________________________________ From: Gilang Sedar|Channel Div.XL|Parastar <[email protected]> To: [email protected] Sent: Thursday, May 12, 2011 15:58:17 Subject: RE: [belajar-excel] Count & sum Bisa dilampirkan contoh nya yang sudah dicoba? Karena itu tadi saya bikin kolom bantu di kolom H, I dan J. *Sembari menunggu rekan-rekan lain nya membantu* Best Regards PARASTAR ECHORINDO |A. G. Sedar | Channel Div. XL | Parastar Team ========================================================= This e-mail, including any attachment is confidential and may be privileged. Use or disclosure of it by anyone other than an intended adressee is strictly prohibited. If you are not an intended addressee, please notify the sender by telephone or e-mail and delete the e-mail and any attachment from your system. PT. Parastar Echorindo. ("the Company") does not accept any liability in respect of communication made by its employee which is contrary to the company policy or outside the scope of the employment of the individual concerned. The employee responsible will be personally liable for any damages or other liability arising. ========================================================= From:[email protected] [mailto:[email protected]] On Behalf Of Niki Dwinarni Sent: Thursday, May 12, 2011 3:19 PM To: [email protected] Subject: Re: [belajar-excel] Count & sum sdh di coba formulanya tapi masih belum bisa/ blm sempurna --- Pada Kam, 12/5/11, Gilang Sedar <[email protected]> menulis: Dari: Gilang Sedar <[email protected]> Judul: Re: [belajar-excel] Count & sum Kepada: [email protected] Tanggal: Kamis, 12 Mei, 2011, 4:29 AM Dear Niki, Apaseperti ini ya, saya seperti biasa, selalu menggunakan kolom bantu. biar keliatan proses nya. Semoga membantu Salam -Gilang Sedar- On 5/12/11, Niki Dwinarni <[email protected]> wrote: > Temen2 B-excell tlg bantuanya gimana formula/rumus biar ngerjain data ga > filter manual... > utk lbh jlsnya...pls see attach file...tq > > > regard > niki > >
Summ Formula .xls
Description: MS-Excel spreadsheet

