+ 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
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,644

    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!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  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
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,644

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,644

    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