Dear Aji.... I hope these code can help you... For next you should join at XL-mania grup....love and peace
=SUMPRODUCT((A1:I6>1)*(A1:I6<8)) love and peace A"Anton"H NS-East -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of milis_aji Sent: Tuesday, July 25, 2006 2:02 PM To: [email protected] Subject: Re: [PCplus] Menghitung angka di excel ...... Makasih... tapi masih ada ganjalan, gimana klo sy kepingin antara angka 2 dan 7 , kl kita coba hitung manual ada 11 angka. sy pakai countif(range,>=2 and <=7) tidak mau kerja...malah dikasih nilai 0..mohon bantuannya.... thx --- In [email protected], Anto <[EMAIL PROTECTED]> wrote: > > Monday, July 24, 2006, 7:23:16 AM, milis_aji wrote: > > > Misal sy punya satu kolom angka seperti : 1,1,2,2,3,4,5,6,6,6,7,8,8 > > bagaimana sy bikin rumus diexcel (diselnya atau macro) spy bs > > menghitung jumlah angka antara 1 dan 4(dalam contoh diatas kita bs > > menghitung manual ada 6 angka, yg di dpt dari angka 1 ada 2, 2 ada 2, > > 3 ada 1 dan 4 ada 1, shg jumlah angka antara 1 dan 4 adalah 6). > > Misalnya urutan angka diatas ada di kolom A1 s/d A13, maka formulanya > =COUNTIF(A1:A13,"<5") > -- > Best regards, > Anto > Yahoo! Groups Links ========================================================= This e-mail, including any attachment is confidential and may be privileged. Use or disclosure of it by anyone other than an intended adressee is strictly prohibited. If you are not an intended addressee, please notify the sender by telephone or e-mail and delete the e-mail and any attachment from your system. PT Excelcomindo Pratama Tbk. ("the " Company") does not accept any liability in respect of communication made by its employee which is contrary to the company policy or outside the scope of the employment of the individual concerned. The employee responsible will be personally liable for any damages or other liability arising. ========================================================= ------------------------ Yahoo! Groups Sponsor --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/SktRrD/hOaOAA/yQLSAA/BRUplB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/mailplus/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
