Dear Titis;

Mungkin begini;


=SUMPRODUCT(('KAS MAS'!$B$6:$B$197=$B14)*('KAS MAS'!$G$6:$G$197-'KAS 
MAS'!$H$6:$H$197))


Copy paste kebawah




Wassalam


~ Bagus ~


  ----- Original Message -----
  From: Mas Karebet
  To: [email protected]
  Sent: Saturday, September 07, 2013 9:39 AM
  Subject: ]] XL-mania [[ aplikasi budget







  Dear master semua,




  bagaimana cara membuat realisasi budget berdasarkan input data harian




  contoh terlampir.




  terima kasih atas bantuan para master sekalian




  best regards,




  titis


  

Kirim email ke