Sum-If formula while using UserForm

[Mohamed Hassan]

Dears,

Please I need your support, actually I don't know what's wrong I did as when I'm trying to use sum-if function in my UserForm I got wrong results (will be reflected in Textbox) comparing the right one when I do it using the same function in Excel .
N.B I'm trying to do it while my criteria will be a (Date) which will be shown in a combobox "as a list".

- Please check the attached UserForm sample for my inquiry.

Thanks In advance

[rorya]

You need to convert the text in the list to a date, then to a number value. Try this:

Please Login or Register  to view this content.

[Mohamed Hassan]

You need to convert the text in the list to a date, then to a number value. Try this:

Please Login or Register  to view this content.

That's why you added "1" to convert it to Number

[rorya]

CLng converts it to a number. The 1 is to make the date string "1 May 2018" for example, rather than just "May 2018". (it's not strictly necessary, as CDate should default to 1st of the month anyway, but I like to be explicit)

[Mohamed Hassan]

Many thanks rorya, for your support & effort

Again , THANK YOU & wishing you a very successful day

[rorya]

Glad to help.