+ Reply to Thread
Results 1 to 7 of 7

Why are my SUMIF formula's returning as 0?

  1. #1
    Registered User
    Join Date
    08-09-2019
    Location
    Sweden
    MS-Off Ver
    365
    Posts
    8

    Question Why are my SUMIF formula's returning as 0?

    I followed the SUMIF formula exactly - even used the same one from an old workbook where it worked for me. It didn't apply to the new workbook and returned everything as 0. I made sure the number columns were saved as number in the toolbar, and that the text was labeled as text (also tried general) - didn't change much.

    So I made a whole new workbook with sample data just to see if I could get it to work at all. The numbers are 1, 2, 3 and the word is Good. Everything that says Good should be added into a third cell.

    Can anyone take a look at my sample workbook (called SUMIF) that's been uploaded and share what I'm doing wrong with the SUMIF to return 0? I've been trying to solve this seemingly simple problem for weeks now. =/
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,350

    Re: Why are my SUMIF formula's returning as 0?

    You have used typographical quote marks - change thenm to straight ones:

    =SUMIF(E4:E6;"Good";D4:D6)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    08-09-2019
    Location
    Sweden
    MS-Off Ver
    365
    Posts
    8

    Re: Why are my SUMIF formula's returning as 0?

    There was an error when I applied your formula to the workbook. Do you mind adding it then uploading so I can see?

  4. #4
    Registered User
    Join Date
    08-09-2019
    Location
    Sweden
    MS-Off Ver
    365
    Posts
    8

    Re: Why are my SUMIF formula's returning as 0?

    EDIT: I just tried and it worked in all the cells except the first one. Had the same problem on my other workbooks. Let's see if I can apply it to the real one now...

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,350

    Re: Why are my SUMIF formula's returning as 0?

    If you are using a UK locale, change the semi-colons to commas:

    =SUMIF(E4:E6,"Good",D4:D6)

    As you are in Sweden, I assumed a European locale.

    Also, make sure there is no training space when you copy and paste the formula - if there is, delete it (backspace key once).
    Last edited by AliGW; 02-09-2020 at 07:41 AM. Reason: Typo corrected.

  6. #6
    Registered User
    Join Date
    08-09-2019
    Location
    Sweden
    MS-Off Ver
    365
    Posts
    8

    Re: Why are my SUMIF formula's returning as 0?

    It seemed to have fixed the problem. THANK YOU so much! =)

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,350

    Re: Why are my SUMIF formula's returning as 0?

    You're welcome!

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

+ 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. SUMIF is not returning any answer
    By danher85 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-27-2018, 06:05 AM
  2. SUMIF formula returning a 0 value
    By the machine in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 04-24-2017, 11:58 AM
  3. sumif returning 0's
    By rcdavis28 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2016, 02:36 PM
  4. Sumif function returning 0
    By Gee246 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-19-2016, 12:54 AM
  5. [SOLVED] SUMIF returning 0
    By TPDave in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-25-2014, 11:38 AM
  6. [SOLVED] SUMIF formula returning negative value & I need it to be positive
    By dosbirn in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-11-2013, 05:10 PM
  7. [SOLVED] SUMIF formula returning a 0 value
    By cf7046 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-21-2013, 01:08 AM

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