+ Reply to Thread
Results 1 to 8 of 8

SUMIFS Formula not working?

  1. #1
    Forum Contributor
    Join Date
    01-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    147

    SUMIFS Formula not working?

    Hi there,

    I have had a go, but going wrong somewhere, would appreciate your help please?

    Please see attached.

    In cell H2, I want the total of column F when column C is Finance Costs and Loan Costs. I.e cell H2 should total 171,267.10

    Thanks all

    N
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-19-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    208

    Re: SUMIFS Formula not working?

    SUMIFS criteria use "AND", not "OR". Since you only have two criteria, adding two SUMIF functions should suffice:

    =SUMIF(C:C,"Finance Costs",F:F)+SUMIF(C:C,"Loan Costs",F:F)

  3. #3
    Forum Contributor
    Join Date
    01-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    147

    Re: SUMIFS Formula not working?

    Hi there,
    Thanks for quick reply and for solving my problem.
    For future reference, I would be grateful if you can show how the formula would be different if I were to use the OR function for future problems and not AND?
    Thanks again

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,066

    Re: SUMIFS Formula not working?

    Try...

    =SUM(SUMIFS(F:F,C:C,{"Finance Costs","Loan Costs"}))
    HTH
    Regards, Jeff

  5. #5
    Forum Contributor
    Join Date
    01-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    147

    Re: SUMIFS Formula not working?

    Hi Jeff,

    Just trying this, but I am trying to apply the formula to another tab.
    Are you able to rewrite the formula if the formula were in sheet 2 please?

    Regards

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,066

    Re: SUMIFS Formula not working?

    Hi N,

    =SUM(SUMIFS(Sheet1!F:F,Sheet1!C:C,{"Finance Costs","Loan Costs"}))

    If you paste the formula from post #4 into sheet 1, you can then cut & paste the formula to whatever sheet you like. The references will auto update.

  7. #7
    Forum Contributor
    Join Date
    01-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    147

    Re: SUMIFS Formula not working?

    Perfect, Thanks so much to all

  8. #8
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,066

    Re: SUMIFS Formula not working?

    You are very welcome. We are happy to help.

    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)

Similar Threads

  1. [SOLVED] SumIfs Formula is not working
    By Eaglepi in forum Excel General
    Replies: 6
    Last Post: 09-18-2018, 10:04 AM
  2. Sumifs formula is not working properly
    By Sanjibghosh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-28-2016, 02:58 AM
  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 formula isn't working correctly
    By gjergji in forum Excel General
    Replies: 5
    Last Post: 09-20-2012, 05:15 PM
  5. [SOLVED] SUMIFS formula not working in VBA
    By meechie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2012, 03:06 PM
  6. Excel 2007 : SUMIFS Formula Not Working
    By milliemoo in forum Excel General
    Replies: 7
    Last Post: 03-06-2012, 12:16 PM
  7. Sumifs formula not working
    By todd.graff@gmail.com in forum Excel General
    Replies: 6
    Last Post: 09-21-2009, 02:26 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