Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
Sumproduct function in vba
Name:
Shinu
Email (spam proof):
Email the originator of this post
Date:
Tuesday, August 01, 2006
Hits:
59
Discussion (Terms and Conditions):
Hi there, I have 2 workbooks named "macros" and "ll2006". There are ranges defined in 2nd workbook. I need to do some analysis in 1st workbook based on the data in 2nd workbook. I am trying to write vba codes, but I dont know how to use the SUMPRODUCT function. Formula :- =sumproduct((MCORPN=c4)*(MCLASS=3)) The above formula I want to use in the vba codes. I dont know how to write it. I tried writing the below given code but it is not working Could you pls. help me witht this. Sub linelist() Set wb = Application.Workbooks("ll2006") Set sh = wb.Sheets("ll") ' Sheet having the database records ' rc[-10] that is Range("C4") . It contains the same data as in MCORPN range Range("M4").Value = _ Evaluate("=SUMPRODUCT((" & sh.Range("MCORPN") & "= rc[-10])*(" & sh.Range("MCLASS") & "=3))") End sub

Sponsored by the best FTP application on the internet: