Hello, I have difficulties in writing this sumpr. formula in vba:
sumproduct(--(A2:A200="A");--(B2:B200)) it ried this but to no avail..combobox1 are the values in A and sumvalue is column B. The formula is supposed to account for changes in the criteria in column A. Thank you very much in advance!
Please Login or Register to view this content.
Hi,
It is hard to see how you have this setup to give a better answer, but
If you want the formula in cell AC1 try:
If you want VBA to calculate it outside the cell from values in a Userform ComboBox you might tryPlease Login or Register to view this content.
WorksheetFunction.Sumproduct( Formula goes in here )
hth
Last edited by davesexcel; 11-29-2010 at 08:46 PM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks