Trimakasih banyak Pak Zainul & MS Jan Raisin, formulanya sangat membantu
BR//billy From: [email protected] [mailto:[email protected]] On Behalf Of zainul_ulum[at]yahoo[dot]com Sent: Thursday, January 10, 2013 4:34 PM To: [email protected] Subject: RE: [belajar-excel] Tanya Multiple sumif atau sum(if(if .. dst Pakai rumus formula array= =SUM(COUNTIF($B$6:$B$15,"*"&D$8&"*")) Untuk jelasnya, silahkan lihat file terlampir -zainul- From: [email protected]<mailto:belajar-excel%40yahoogroups.com> [mailto:[email protected]<mailto:belajar-excel%40yahoogroups.com>] On Behalf Of Muhamad Abdillah XA Sent: Thursday, January 10, 2013 4:12 PM To: [email protected]<mailto:belajar-excel%40yahoogroups.com> Subject: [belajar-excel] Tanya Multiple sumif atau sum(if(if .. dst Hi XL'ers, Mohon bantuannya bagaimana untuk menterjemahkan "contain" dalam rumus sum if multiple ini atau sum(if(if... Terlampir contoh kasusnya BR//billy
