+ Reply to Thread
Results 1 to 4 of 4

SumIfs that cannot sum the Date to its month range

  1. #1
    Registered User
    Join Date
    12-28-2014
    Location
    Malaysia
    MS-Off Ver
    Professional 2007
    Posts
    21

    SumIfs that cannot sum the Date to its month range

    Hi,
    Need help as my Sumif not able to sum the date to month range

    Month / Qty
    Date Product Qty Delivered Product Jan Feb Mar
    2-Jan-15 A 1 1 A =SUMIFS(C3:C7,B3:B7,F3:F7,A3:A7,G2:I2)
    15-Jan-15 B 2 Canx B
    2-Feb-15 B 3 0
    15-Feb-15 A 4 0
    15-Jan-15 A 5 0


    **If Cell D has Canx, then, it dont count qty.
    The result shall be

    Month
    Product Jan Feb Mar
    A 6 4 0
    B 0 3 0
    Attached Files Attached Files

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: SumIfs that cannot sum the Date to its month range

    Using your posted workbook,
    this regular formula, copied across and down, returns the monthly Qty sums
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    12-28-2014
    Location
    Malaysia
    MS-Off Ver
    Professional 2007
    Posts
    21

    Re: SumIfs that cannot sum the Date to its month range

    Thanks for the help... I copy down to G3 and it all return to 0 value.. Sorry the formula don't work .....

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: SumIfs that cannot sum the Date to its month range

    When I tried it, it gave me 6?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] Using SUMIFS to count the number of inquiries per month based on the date of inquiry
    By Tryin2Excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-25-2014, 04:11 AM
  2. [SOLVED] Sumifs and extracting month from range
    By Andrew-Mark in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-24-2013, 07:12 AM
  3. [SOLVED] SUMIFS and Date Criteria (Month Year etc...) but without helper column?
    By JungleJme in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-16-2013, 07:21 AM
  4. [SOLVED] Use TEXT function as Criteria on Sumifs to convert month/year to date format
    By chico.corrales in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-08-2012, 07:49 PM
  5. SumIFS() filtered by the month of a date cell
    By truecrisis in forum Excel General
    Replies: 2
    Last Post: 07-06-2010, 07:57 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1