Dear Nopenk;
Mungkin begini;
=SUMPRODUCT((A2='DATA AWAL'!$A$2:$A$21)*('DATA
AWAL'!$B$2:$B$21))-SUMPRODUCT((A2=INV.BATAL!$A$2:$A$6)*(INV.BATAL!$B$2:$B$6))
Copy Paste kebawah
Wassalam
~ Bagus ~
----- Original Message -----
From: Eko Noviyanto
To: belajar-excel@yahoogroups.com
Sent: Wednesday, September 04, 2013 3:04 PM
Subject: [belajar-excel] FILTER DATA
Dear Master XL,
Mohon bantuannya untuk case terlampir.
Terimakasih diucapkan atas bantuannya.
Salam,
Nopenk
