Dear all


I am struggling with seemingly very simple thing. The following SumIfs returns 0 in the VBA:

Please Login or Register  to view this content.
start_date and end_date are dates defined at the beginning of each run and are 100% correct, i.e. they are date and start_date is lower than end_date. Range("B:B") stores the numbers I need to sum, Range("A:A") stores the dates associated with the numbers. When I apply the same formula in the Excel itself, it works like a charm:

Please Login or Register  to view this content.
In this case, "start_date" and "end_date" are names of the cells, where the date is stored. Can anybody help please to make the VBA version of this simple function working?

Thanks a lot,
Ivan