Bang Zam rumusnya tak pinjam bentar ya.. : )) pake aja rumus ini..
=SUMPRODUCT((range data>=limit bawah)*(range data<=limit atas)) atau pake array formula =SUM((range data>=limit bawah)*(range data<=limit atas)) tp jgn lupa pake CSE cheers, VD [email protected] Sent by: [email protected] 12/19/2008 05:34 PM Please respond to [email protected] To XL-mania <[email protected]> cc Subject ]] XL-mania [[ Mencari jumlah data range value di dalam range data Dear Teman2, Mohon pencerahannya bagaimana mengitung jumlah value range di dalam suatu range --------------------------------------------------------------------------- ABN AMRO Bank N.V. is a subsidiary undertaking of The Royal Bank of Scotland Group plc. This message (including any attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorised use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. ABN AMRO Bank N.V, which has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587, including its group companies, shall not be liable for the improper or incomplete transmission of the information contained in this communication nor for any delay in its receipt or damage to your system. ABN AMRO Bank N.V. (or its group companies) does not guarantee that the integrity of this communication has been maintained nor that t his communication is free of viruses, interceptions or interference. --------------------------------------------------------------------------- ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
<<image/gif>>
<<image/gif>>
