Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    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!

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    Would a DSum() work? I would do that or open a recordset on an SQL statement that summed the appropriate records.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts