+ Reply to Thread
Results 1 to 6 of 6

Sumifs Formula Not Working While two criteria & between two dates

  1. #1
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,885

    Sumifs Formula Not Working While two criteria & between two dates

    In excel 2007, my sumifs formula not working with two criteria & between two dates.
    I have attach sample file.
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,904

    Re: Sumifs Formula Not Working While two criteria & between two dates

    Hi avk,

    First, unmerge cells in col A and extend values in all rows, then use this formula.

    Enter formula in C4 and copy across and down

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,239

    Re: Sumifs Formula Not Working While two criteria & between two dates

    Hope this works
    Attached Files Attached Files

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,885

    Re: Sumifs Formula Not Working While two criteria & between two dates

    Dear Alkey Sir, I use data validation & change segment from Spares to "Oil" or "Fil" or "V/B" then amount showing "Zero" I have attach sample file.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    02-07-2013
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    290

    Re: Sumifs Formula Not Working While two criteria & between two dates

    Hi avk,
    You've probably missed this:
    First, unmerge cells in col A and extend values in all rows, then use this formula.
    One more thing, your drop down in calculation sheet having "Oil" with no trailing space.

    Regards,
    Khalid

  6. #6
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,885

    Re: Sumifs Formula Not Working While two criteria & between two dates

    Yes Khalidngo. Thanks

+ 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] sumifs criteria isn't working
    By noclue1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-25-2015, 10:17 AM
  2. [SOLVED] Multiple SUM Criteria - DSUM and SUMIFS not working :-(
    By Coeus in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-15-2015, 04:05 PM
  3. [SOLVED] SUMIFS formula not working with Dates
    By Bigred25 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-11-2014, 10:25 AM
  4. Sumifs between Dates not working
    By newbi004 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2013, 05:47 AM
  5. Sumifs (criteria between two dates)
    By Arcanus in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-13-2013, 02:16 PM
  6. Sumifs with dates as criteria
    By MARKSTRO in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-19-2013, 05:58 PM
  7. sumifs with dates not working
    By paualou76 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-30-2011, 08:33 PM

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