+ Reply to Thread
Results 1 to 2 of 2

Formula needed based on multiple criteria in date range - WS attached

  1. #1
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    Formula needed based on multiple criteria in date range - WS attached

    WS atttached

    (Dashboard) J6 = Formula
    On “Dashboard”, when a start date(G1) /end date(G2) is entered,
    Formula will return based on that date range from “MAIN” B3:B1002,
    And multiply the number in”MAIN” N3:N1002 by the number listed in “MAIN” AD3:AD1002
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    Re: Formula needed based on multiple criteria in date range - WS attached

    WS attached

    (Dashboard) J6 = Formula
    On “Dashboard”, when a start date(G1) /end date(G2) is entered,
    Formula will return based on that date range from “MAIN” B3:B17,
    And multiply the number in”MAIN” N3:N17 by the number listed in “MAIN” AD3:AD17
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula needed to sum multiple cells based on date range
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2018, 10:07 AM
  2. [SOLVED] Formula Needed to auto pop the # 1 in cell based on when date entered and match criteria
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2017, 10:38 PM
  3. [SOLVED] Formula Needed to populate info from one sheet to another based on cell entry, WS attached
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-28-2017, 12:45 PM
  4. [SOLVED] sumif & countif formula needed based on dd/mm/yy format - worksheet attached
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-28-2013, 11:32 AM
  5. [SOLVED] Formula needed for counting cells based on today's date - see attached worksheet
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-16-2013, 07:06 PM
  6. Worksheet Attached - Formula needed to calculate commissions vs date and Emp ID #
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-02-2013, 12:36 AM
  7. Help needed for Formula that counts based on Date & 3 criteria
    By sellim in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2012, 02:30 PM

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