ComboBox Value in WorkSheetFunction SumIfs

[Hmerman]

Hello,
Hope you are well.

Is it possible to use a combobox value in the SumIfs WorkSheetFunction?

As I have the below code that caculates the Net Value of weights in Column E on Sheet11 if the Farm name and Type of Drying method for grapes is in Column A and C. The Farm name and Drying method is got from two ComboBox. But it calculates to zero.

Dim pResult as Double
Dim nettRang as Range, frmRang as Range, drgRang as Range

With Sheet11[INDENT]Set nettRang = .Range("E:E")
[/INDENT]
        Set frmRang = .Range("A:A")
        Set drgRang = .Range("C:C")
           pResult = Application.WorksheetFunction.SumIfs(nettRang, frmRang, " = "  & cbPlFarms.Value, drgRang, " = " & cbPlDroog.Value)
                
                Sheet3.Range("A15").Value = pResult
    
    End With

Can someone please assist or give advice?

Regards

 

[Hmerman]

Just for clarity.

cbPlFarms.Value

and

cbPlDroog.Value

are combobox values.

 

[Hmerman]

Update:
I have tried placing the combobox values on the Sheet and using the Range.Value as argument in the WorkSheetFunction Sumifs method and noticed that it still caculates to zero. Therefore there must be something wrong with my SumIfs setup:

pResult = Application.WorksheetFunction.SumIfs(nettRang, frmRang, " = "  & cbPlFarms.Value, drgRang, _
 " = " & cbPlDroog.Value)

Can someone please tell me if they see anything out of place?

P.S. I have checked with the normal/non VBA SumIfs function to check what the answer should be and
it is 4345 kg not zero. I must use VBA SumIfs as the Farm name variable and Drying method variable change to often along with percentages to place them on the Sheet.

The calculation is done from a Userform.