Coba dengan rumus andalan XLmania. =SUMPRODUCT(($B$5:$B$20=$K16)*($C$5:$C$20=$L16)) Regards,
-hendra- "This message, including attachments, is confidential and may be privileged. If you are not an intended recipient, please notify the sender then delete and destroy the original message and all copies. You should not copy, forward and/or disclose this message, in whole or in part, without permission of the sender." P Save a tree...please don't print this e-mail unless you really need to From: raya hidayat Sent: Friday, January 30, 2009 7:58 AM To: [email protected] Subject: ]] XL-mania [[ count cell bermasalah Dear XL-Mania. aku menemui masalah dengan countif. mohon bantuannya -- Terima kasih Raya
