Hai Andre;
Coba begini:
=SUMPRODUCT(($A2='Data Base'!$A$2:$A$13)*($C2=--'Data
Base'!$D$2:$D$13)*(D$1='Data Base'!$E$2:$E$13)*('Data Base'!$C$2:$C$13))
Copas kebawah dan kekanan
Wassalam
~ Bagus ~
----- Original Message -----
From: Andre Rahmaidy
To: [email protected]
Sent: Tuesday, April 29, 2014 5:18 PM
Subject: [***SPAM*** Score/Req: 05.10/5.0] [belajar-excel] Copy Data Ke Sheet
Lain Berdasarkan Kriteria [1 Attachment]
Dear Beexceller
saya tanya mengenai rumusan / formula excel secara otomasi angka yang ada di
sheet database menyesuaikan pada sheet isi sesuai berdasarkan kriterianya
masing masing-masing (file terlampir)
