Sumproduct in vba?

[fcb1900]

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!

Range("AC1").Formula = "=sumproduct(--(Me.ComboBox1 & """" ),--(sumvalue)"

[MarvinP]

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:

Range("AC1").Formula = "Sumproduct(--(A2:A200=""A""),--(B2:B200)) "

If you want VBA to calculate it outside the cell from values in a Userform ComboBox you might try
WorksheetFunction.Sumproduct( Formula goes in here )

hth