sudah saya coba dengan hasil :
WorksheetFunction.SumProduct(evaluate("(F2:F34=N16)*(G1:L1=O16)*(G2:L34)"))
=== yg ini bisa .
WorksheetFunction.SumProduct([(F2:F34=N16)*(G1:L1=O16)*(G2:L34)]) == yg
ini error.
didalam function nga mau terima *:* kecuali *:* nya ada didalam range
Range("N48").Value = .SumProduct((Range("F2:F35") = Range("C48")) *
(Range("G1:L1") = Range("D48")) * (Range("G2:L35")))
juga gagal .
selain cara .SumProduct(Evaluate ---- yg lain nya belum saya temukan .
salam
Lukman
2012/11/20 summonery <[email protected]>
> **
>
>
> Coba juga teknik penggunaan sumproduct melalui macro berikut ini,
>
>
> WorksheetFunction.SumProduct(evaluate("(F2:F34=N16)*(G1:L1=O16)*(G2:L34)")
> )
>
> atau,
>
> WorksheetFunction.SumProduct([(F2:F34=N16)*(G1:L1=O16)*(G2:L34)])
>
>
> (Evaluate method menghasilkan array (satu-satunya yang dimaui sumproduct)
> yang kemudian diumpankan ke WorksheetFunction.SumProduct)
>
> ---------
> The advantage of using square brackets is that the code is shorter. The
> advantage of using Evaluate is that the argument is a string, so you can
> either construct the string in your code or use a Visual Basic variable.
> ---------
>
> >semoga bermanfaat
------------------------------------
---------------------------------------------------------------------
bergabung ke milis (subscribe), kirim mail kosong ke:
[email protected]
posting ke milis, kirimkan ke:
[email protected]
berkunjung ke web milis
http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran
http://www.mail-archive.com/[email protected]/
atau (sejak 25-Apr-2011) bisa juga di :
http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: [email protected]
keluar dari membership milis (UnSubscribe):
kirim mail kosong ke [email protected]
---------------------------------------------------------------------Yahoo!
Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-excel/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-excel/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> 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/
