Good afternoon,
The following is not an easy question but, I hope, something can help me with that.

Basically what I want to do is a conditional sum (SUMIFS) in Vba.

I would like to sum certain values contained in a worksheet of mine (VBS is its name). IF and only IF the corresponding initial and final DATE (such values are associated to an event with an INITIAL date and an END date) are between a certain date range (monthly).

Obviously I also need to loop over the rows of VBS to "catch" all the values.

Let us say that an event which value is 500$ starts 02/04/2020 and ends 04/07/2020: in this case I would like to pick the value (500$) associated to the event and use it to populate the second, third and 4th position of my 1D array "arr_date" -> arr_date (1) = arr_date (2)=arr_date(3)= 500.

Does anyone have an idea about how to cope with the problem?

Thank you to all.