I am having a problem with the Application.Sumif function in vba

[updown]

Hi everyone,

I have this code:

Sub Sumif()

Dim Sum As Long


Description = UserForm2.comboClothing.Value


Sum = Application.SumIf(Sheets("Inventory").Range("F2:F1014"), Description, Sheets("Inventory").Range("D2:D1014"))

MsgBox Sum


End Sub

The value that is returned is always zero. I can't seem to figure out why. Thanks in advance for any help!