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
> >
> >
>
>     
>

Kirim email ke