Unanswered: Sumif in array with range as criteria? (VBA)
I have written a procedure in VBA that will return an array with two columns. The first column will contain dates, the second contains cashflows on the dates.
What I now need to do is test the dates against a certain period. If a cashflow falls in the period i have to select it. If multiple cashflow fall in the period if have to add them up. The summed cashflows would be the desired outcome.
Does anyone have an idea how to do this in vba? Obviously a dlookup is not sufficient and I don't know how else to do it.
Nobody dies a virgin because life screws us all!