Walah keduluan Mr.Kid buat jawab. hehehehe 

 

 

 

 

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 Mr. Kid
Sent: Thursday, May 12, 2011 6:23 PM
To: [email protected]
Subject: Re: [belajar-excel] Formula untuk Sum minus

 

  

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*

 

 

Error! Filename not specified.

 

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