+ Reply to Thread
Results 1 to 8 of 8

Can't use sumifs() condition for multiple criteria

  1. #1
    Registered User
    Join Date
    06-12-2014
    Posts
    22

    Can't use sumifs() condition for multiple criteria

    Dear sir,

    I can't use sumifs() condition for multiple options,

    Herewith I have attached the excel file please help me with this
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,799

    Re: Can't use sumifs() condition for multiple criteria

    Hi and welcome to the forum

    It would help if you provided a few sample answers, however, when using sumifS(), the 1st range is the sum range, not the criteria range - you are using B:B, which contains no numbers.

    TYpe in =sumifS( and then click on the Fx to the left ofthe formula bar. It will guide you though what you need
    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

  3. #3
    Registered User
    Join Date
    06-12-2014
    Posts
    22

    Re: Can't use sumifs() condition for multiple criteria

    Dear Mr.Ford

    Thanks for the reply

    Please check the attachment now

    The formula that I entered in the cell H5 in summary sheet is working

    But The formula that I used in the cell H6 is not working

    I don't know why it is not accepting if I add a second criteria_range & createria

    Please go through & Help me for this formula sir

    Thank you

    Regards
    Venkatesh.S
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Can't use sumifs() condition for multiple criteria

    Instead of your formula, try using,
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,640

    Re: Can't use sumifs() condition for multiple criteria

    On sheet3, in H5 try this....
    Please Login or Register  to view this content.
    and then drag across and down.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  6. #6
    Registered User
    Join Date
    06-12-2014
    Posts
    22

    Re: Can't use sumifs() condition for multiple criteria

    Dear Mr.sktneer

    Thank you very much

    It is 100% working

    But Still small change is needed

    That is,

    The summary is perfectly coming for the data's that I enter in cell C5 To C16 in CSM report page, but when I enter data in C17 (CSM REPORT) or after that it is not getting added in the summary sheet.

    So please revise the formula and update.

    The formula is exactly working as what I thought but it should work for all the data that I enter in C column.

    Please help

    Thanks & regards,
    Venkatesh.S

  7. #7
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,640

    Re: Can't use sumifs() condition for multiple criteria

    See the attached sheet.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    06-12-2014
    Posts
    22

    Re: Can't use sumifs() condition for multiple criteria

    Thank you very much Mr.sktneer

    Its working...


  9. #9
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,640

    Re: Can't use sumifs() condition for multiple criteria

    You're welcome. Thanks for the feedback.

+ 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. SumIfs with multiple criteria using VBA
    By newbi004 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-04-2013, 10:21 AM
  2. Replies: 2
    Last Post: 01-23-2013, 06:25 AM
  3. Replies: 3
    Last Post: 11-21-2012, 04:57 PM
  4. Replies: 1
    Last Post: 05-16-2011, 05:00 PM
  5. SUMIFS with multiple or/and/not Criteria
    By TACAMO in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2010, 03:35 PM

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