SUMIFS with 3 criteria in Userform- Excel VBA

[CakzPrimz]

Dear Folks,

I need your help, I'm trying to get the extract the number based on multiple criteria in a userform with SUMIFS from a certain period.

UserForm name = UserForm3

Private Sub ComboBox3_Change

    Dim S_Date As Date 'Start Date
    Dim E_Date As Date 'End Date

    Set S_Date = UserForm3.ComboBox1.Value
    Set E_Date = UserForm3.ComboBox2.Value

End Sub

Train3_Actual.Value = Application.WorksheetFunction.SumIfs(Sheet1.Range("E3:E842"), Sheet1.Range("B3:B842"), " >= " & S_Date, Sheet1.Range("B3:B842"), " <= " & E_Date, "T - TRAIN 3")

It says, "Object required". I

Thanks in advance.

 

[CakzPrimz]

Private Sub ComboBox3_Change

    Dim S_Date As Date 'Start Date
    Dim E_Date As Date 'End Date

    Set S_Date = UserForm3.ComboBox1.Value
    Set E_Date = UserForm3.ComboBox2.Value

[FONT=Verdana]      Train3_Actual.Value = Application.WorksheetFunction.SumIfs(Sheet1.Range("E3:E842"), Sheet1.Range("B3:B842"), " >= " & S_Date, Sheet1.Range("B3:B842"), " <= " & E_Date, "T - TRAIN 3")[/FONT]

End Sub

 

[CakzPrimz]

The first code below give no error, but the value is 0, the correct value is 18,000

Private Sub ComboBox3_Change()
    Dim S_Date As Date
    Dim E_Date As Date
    
    S_Date = Me.ComboBox1.Value
    E_Date = Me.ComboBox2

Train3_Actual.Value = Application.WorksheetFunction.SumIfs(Sheet1.Range("E3:E842"), Sheet1.Range("B3:B842"), " >= " & Sheet11.Range("AA11").Value, Sheet1.Range("B3:B842"), " <= " & Sheet11.Range("AB11").Value, Sheet1.Range("C3:C842"), "T - TRAIN 3").Value

The second code resulting Runtime error '1004'
Unable to get the Sumifs property of the WorkshetFunction class

Train3_Actual.Value = Application.WorksheetFunction.SumIfs(Sheet1.Range("E3:E842"), Sheet1.Range("B3:B842"), " >= " & CLng(S_Date), Sheet1.Range("B3:B842"), " <= " & CLng(E_Date), "T - TRAIN 3")

The third code resulting Runtime error '1004'
Unable to get the Sumifs property of the WorkshetFunction class

Train3_Actual.Value = Application.WorksheetFunction.SumIfs(Sheet1.Range("E3:E842"), Sheet1.Range("B3:B842"), "" >= "" & S_Date, Sheet1.Range("B3:B842"), "" <= "" & E_Date, "T - TRAIN 3")

 

[CakzPrimz]

When I try to write the formula in the sheet as below:

=SUMIFS(Backfill[ACTUAL],Backfill[DATE],">="&$AA$11,Backfill[DATE],"<="&$AB$11,Backfill[AREA],Z11)

It gave me the right answer.

Will somebody help me please, I have completely lost.

Thank you