+ Reply to Thread
Results 1 to 5 of 5

Sumif discontinuos data on 1 row

  1. #1
    Registered User
    Join Date
    12-07-2018
    Location
    Brisbane, Australia
    MS-Off Ver
    2016
    Posts
    2

    Unhappy Sumif discontinuos data on 1 row

    I have a spreadhseet that forecasts and tracks project invoicing. I am trying to calculate the total sum of claims in 'D13' for respective months 'H13,K13,N13....' ONLY if they have been sent (Y) 'I13,L13,O13....'

    I have made a simple SUMIF(I13,"Y",H13)+SUMIF(L13,"Y",K13)+.... But i want to know if there is a better way around this so i can easily update the ranges when i create new columns in months/years to come.

    Thanks.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    21,341

    Re: Sumif discontinuos data on 1 row

    Welcome to the forum!

    Try the SUMIFS function. Without seeing your workbook, I can't be more specific.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  3. #3
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Excel 2010
    Posts
    6,665

    Re: Sumif discontinuos data on 1 row

    Hi,

    =SUMIF(I13:XFD13,"Y",H13:XFC13)

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  4. #4
    Registered User
    Join Date
    12-07-2018
    Location
    Brisbane, Australia
    MS-Off Ver
    2016
    Posts
    2

    Re: Sumif discontinuos data on 1 row

    FORECAST.JPG

    Attached is a snapshot of the spreadsheet i'm trying to 'fix' - 'D' is where i want the total of 'H, K, N...' based on 'I, L, O...' being "Y".

    NB: i believe XOR LX 's answer solved this. Thank you

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    21,341

    Re: Sumif discontinuos data on 1 row

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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