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

Attachment: Summ Formula .xls
Description: MS-Excel spreadsheet

Kirim email ke