Results 1 to 6 of 6

Need help to add a date range variable to a forumla

Threaded View

  1. #1
    Registered User
    Join Date
    09-06-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    17

    Need help to add a date range variable to a forumla

    OK so first let me explain what we have here,
    In column AB is where my receipt numbers are, this should be populated with something before being included in the calculation.

    In F2 is where the currency is listed ex. CAD, AUD

    C2 is on the page where the formula resides. It’s my results tab. C2 is the cell that the formula referrers to when checking which currency to sum up
    .
    E is the column where all the dollar values reside

    Now what I’m looking to add to this formula is the following.
    On the results tab, where C2 is I want to be able to input a “from” date and “to” date range. I want everything between equal to or between the date ranges to be calculated along with the rest of the variables. These dates are found in column AC.

    I’ve attached a sample of the document I’m referring to.

    =SUMPRODUCT((Grid!AB2:AB24921<>"")*((Grid!F2:F24921)=C2),Grid!E2:E24921)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1