+ Reply to Thread
Results 1 to 4 of 4

Help Required with Sumif, Sumifs function

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    Pune
    MS-Off Ver
    Excel 2007
    Posts
    23

    Help Required with Sumif, Sumifs function

    Hi,

    I need to use sumif function for suming up the values for my excel sheet. My problem is the criteria cells that i have are not continuous which is why I can't use it. Please refer to the attached excel to understand my requirement better.

    In the example, I need sum of all defects release number wise.

    Can anyone suggest a solution?


    Thanks,

    Shantanu
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: Help Required with Sumif, Sumifs function

    you only have 1 row of data i assume this would not be the case alsoe you have no headers or anything

    i think you could probably do what you need with SUMPRODUCT

    but without more information i think it will be hard to give you a decent answer
    The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
    <--- If a post helps hit the star

  3. #3
    Registered User
    Join Date
    08-16-2012
    Location
    Pune
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Help Required with Sumif, Sumifs function

    Hi,

    Thanks for the quick reply. Find attached the modified file with headers added.

    Yes, I have only one row of data and agreeably my requirement is a strange one

    Thanks in advance for your help.

    Shantanu.
    Attached Files Attached Files

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Help Required with Sumif, Sumifs function

    Hi Shantanu,

    Try using below formula:-

    {=SUM(SUM(OFFSET($A$4,0,IF($B$4:$I$4=$C8,COLUMN($B$4:$I$4)-2,0))))}

    See attached:- Sample_1.xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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