Anda Bertanya Kami Menjawab All About Microsoft Office 2007 Word, Excel, Powerpoint
capai target: =SUMPRODUCT((C3:C14>=600)*(SUBTOTAL(103,OFFSET(C3,ROW(C3:C14)-MIN(ROW(C3:C14)),0)))) tidak mencapai target: =SUMPRODUCT((C3:C14<600)*(SUBTOTAL(103,OFFSET(C3,ROW(C3:C14)-MIN(ROW(C3:C14)),0)))) wah mantap.. cek kulkas gan :cendols