Results 1 to 4 of 4

SUMIF with Date Parameters

Threaded View

  1. #1
    Registered User
    Join Date
    09-24-2015
    Location
    London, England
    MS-Off Ver
    Office 2013
    Posts
    31

    Question SUMIF with Date Parameters

    Good Afternoon!

    I'm looking for a formula that will return the total billings per candidate but only those that fall within certain date parameters.

    I have attached a sample workbook for ease of explanation.
    Within column D (Current Placements) I need the formula to return the total amount invoiced per candidate but only those with invoice dates that fall within the placement dates.

    I have tried a SUMIFS with some greater than and less than but it didn't like that. (I've left my formula in with speech marks so you can see my error).

    Any help would be HUGELY appreciated!!
    Many thanks,
    Laura
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sumif a range based on multiple parameters
    By ifthenelsenull in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-14-2014, 05:21 AM
  2. Input Date Parameters
    By murtaza.khan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2014, 03:21 AM
  3. SUMIF by Date - SUMIF by Date = #VALUE when linked worksheet not open
    By alexhartley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-14-2013, 03:56 AM
  4. Replies: 1
    Last Post: 07-23-2012, 05:13 PM
  5. [SOLVED] SUMIF(By Date) - SUMIF(By Date)= #Value Error From Linked Data
    By Dragunov in forum Excel General
    Replies: 2
    Last Post: 05-17-2012, 11:22 AM
  6. SQL Date Parameters
    By Gyto in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-20-2010, 06:35 AM
  7. SumProduct with date parameters
    By Petercw in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-01-2010, 06:36 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