+ Reply to Thread
Results 1 to 4 of 4

Extracting data between two dates based on three inputs

  1. #1
    Registered User
    Join Date
    05-11-2015
    Location
    Denmark, KBH
    MS-Off Ver
    2013
    Posts
    8

    Extracting data between two dates based on three inputs

    Hi

    I have a problem where I need to extract the data between two dates (in this case revenue) from a matrix. The data the formula should be finding should be defined by inputting two dates and a column name. I've tried attaching a spreadsheet but this function doesn't work for me for some reason. So I've attached an image instead which hopefully underlines the problem in a better manner. I've tried sumifs in shapes and sizes but no luck. Does anybody have any ideas?

    Snip.PNG

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Extracting data between two dates based on three inputs

    =sum(($e$4:$e$10>=$c$6)*($e$4:$e$10<=$c$7)*($f$3:$i$3=$c$8)*$f$4:$i$10), cse

  3. #3
    Registered User
    Join Date
    05-11-2015
    Location
    Denmark, KBH
    MS-Off Ver
    2013
    Posts
    8

    Re: Extracting data between two dates based on three inputs

    Well, that was a quick solution. Thanks!

  4. #4
    Registered User
    Join Date
    06-22-2018
    Location
    TX
    MS-Off Ver
    Office 2016
    Posts
    4

    Re: Extracting data between two dates based on three inputs

    Thanks, I was having a similar problem.

+ 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. [SOLVED] Extracting data from different Sheets based on Dates
    By Rhic07 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2017, 04:07 AM
  2. Extracting Dates every Nth row based on Max Value
    By Siftbaker in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2017, 04:12 PM
  3. [SOLVED] Vlookup on Dates and generating date range based upon inputs
    By Chardo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-14-2014, 05:13 PM
  4. Extracting data based on dates
    By jodapo in forum Excel General
    Replies: 4
    Last Post: 08-07-2009, 09:10 PM
  5. Extracting Chart Data and Adjustable Inputs through VBA
    By maani in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2009, 04:37 AM
  6. How to rearrange order based on dates of inputs?
    By FISH in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-21-2005, 09:05 AM
  7. How to rearrange order based on dates of inputs?
    By FISH in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2005, 09:05 AM

Tags for this Thread

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