hai raya hidayat, seperti kata pak zamproduct: "jangan lupakan zamproduct" =SUMPRODUCT(($B$5:$B$20=E14)*($C$5:$C$20=F14))
seperti kata bu guru siti vi: "jangan lupa lihat2 arsip milis" http://tech.groups.yahoo.com/group/XL-mania/message/7686 regards, abimono On 1/30/09, raya hidayat <[email protected]> wrote: > > Dear XL-Mania. > > aku menemui masalah dengan countif. > mohon bantuannya > > -- > Terima kasih > > > Raya > > ------------------------------------ >
countif problem.xls
Description: MS-Excel spreadsheet
