Terima kasih, hatur nuhun, dan matur nuwun mas Bagus, inilah yang saya cari-cari. moga diberi rejeki yang melimpah.. :D
--- In [email protected], "Bagus" <bagus@...> wrote: > > Dear Frendy; > > Mungkin begini: > =SUMPRODUCT(($H3=$A$2:$A$7)*(I$2=$D$1:$F$1)*($C$2:$C$7*$D$2:$F$7)) > Copy-paste kekanan dan kebawah. > > File terlampir. > > > Wassalam > > ~ Bagus ~ > > ----- Original Message ----- > From: Frendy R > To: [email protected] > Sent: Sunday, May 12, 2013 9:32 PM > Subject: [belajar-excel] Sum Product dengan Kriteria
