Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: SUMIFS function has suddenly stopped working in one cell
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,117
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: SUMIFS function has suddenly stopped working in one cell

    Quote Originally Posted by Aladin Akyurek View Post
    Does the following work?...

    =SUMIFS(G:G,D:D,"*Mural*")
    Quote Originally Posted by KenDue View Post
    I believe Aladin is onto the right idea with using the wildcard character "*Mural*" in the formula, but the formula still needs to be
    =SUMIF(D:D,"*Mural*",G:G) (with the criteria in the center of the column designations). I've tested this and it works perfectly, even if the word "mural" is all lowercase. I'm guessing your sheet has a leading or trailing space where "mural" is listed that the wildcard character will take care of.
    Quote Originally Posted by Guru008 View Post
    Hi

    Structure of your sumif formula is wrong

    Sumif(Range, Criteria, SumRange)

    always use "=Text" while not referring a cell
    =SUMIFS(G:G,D:D,"*Mural*")

    =SUMIF(D:D,"*Mural*",G:G)

    are exactly equivalent in behavior. The latter can be considered obsolete (also COUNTIF and AVERAGEIF).
    Assuming too much and qualifying too much are two faces of the same problem.

  2. #12
    New Member
    Join Date
    Oct 2016
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: SUMIFS function has suddenly stopped working in one cell

    Aladin,

    After seeing your post directly above, I re-tried the formula you gave, and see that it does indeed work the same. I was not aware that the SUMIFS formula had outdated SUMIF as you described... I thought SUMIFS was only used where more than one criteria was desired. Thanks for the education!

  3. #13
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,117
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: SUMIFS function has suddenly stopped working in one cell

    Quote Originally Posted by KenDue View Post
    Aladin,

    After seeing your post directly above, I re-tried the formula you gave, and see that it does indeed work the same. I was not aware that the SUMIFS formula had outdated SUMIF as you described... I thought SUMIFS was only used where more than one criteria was desired. Thanks for the education!
    Qualification "obsolete" is rather a personal opinion:

    COUNT, COUNTA: 0 arg; COUNTIF:1 arg; COUNTIFS: >=1 arg(s)
    SUM: 0 arg; SUMIF: 1 arg; SUMIFS: >= 1 arg(s)
    AVERAGE: 0 arg; AVERAGEIF: 1 arg; AVERAGEIFS: >=1 arg(s)
    MAX: 0 arg; no MAXIF: 1 arg; MAXIFS: >= 1 arg(s)
    MIN: 0 arg; no MINIF: 1 arg; MINIFS: >= 1 arg(s)

    >= 1 arg(s) motivates my reason regarding just 1 arg versions.
    Assuming too much and qualifying too much are two faces of the same problem.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •