selamat pagi di C19 =SUMPRODUCT(($B$6:$B$10=$B19)*(C$6:C$10<>0)) tarik ke kanan dan bawah
thank you and regards, - abimono - 2012/9/20 Cabang Padang <[email protected]> > ** > > > to Master excel > > mohon bantuannya untuk formula terlampir, > terimakasih > > idal > > Reply > to<[email protected]?subject=Re%3A%20sumproduct%20atau%20countif> >
xlmania.xls
Description: MS-Excel spreadsheet
