Results 1 to 4 of 4

SUMIF needed for item based on date range

Threaded View

  1. 06-16-2019, 04:55 PM #1
    excelteam777
    excelteam777 is offline
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    SUMIF needed for item based on date range

    WS attached

    I need a sumif formula based on date ranges entered.
    Formula goes into J5
    Start Date Range: F1 , Stop Date Range: F2

    I need a sum from J11:J1110 only for the matching text in C5
    based on the date range from E11:E1110 that fall between a date range entered into F1-F2.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula Needed to SUMIF columns based on a date range entered
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2017, 11:18 PM
  2. Find the top 10 item in dynamic date range based on condition
    By Villalobos in forum Excel General
    Replies: 3
    Last Post: 03-22-2014, 01:54 PM
  3. [SOLVED] Formula needed for countif and sumif based on date format 12/23/13, etc.
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-28-2013, 10:50 AM
  4. SUMIF Based on a date range
    By pstewart in forum Excel General
    Replies: 5
    Last Post: 08-13-2012, 02:24 AM
  5. SUMIF Based on Date Range - Help Please :)
    By Kpauly in forum Excel General
    Replies: 3
    Last Post: 02-06-2012, 03:23 PM
  6. Help needed with date range based analysis
    By SG2 in forum Excel General
    Replies: 2
    Last Post: 07-28-2010, 04:00 AM
  7. Sumif based on a text criteria and a date range
    By PiR1 in forum Excel General
    Replies: 2
    Last Post: 06-02-2010, 12:53 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1