Untuk sum yang negatif saja : (data di D5:P5) =SUMIF(D5:P5,"<0")
Yang positif saja ? punya ide ? Kid. On Thu, May 12, 2011 at 18:19, Didin Rahardian <[email protected]>wrote: > > > 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 > > > > > > >

