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
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.
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
Code:
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.