1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SUMIFS formula returning 0 incorrectly

Discussion in 'Ask an Excel Question' started by Hayley, Oct 11, 2017.

  1. Hayley

    Hayley Member

    Messages:
    39
    Hi, this formula used to work on this report, but the last few months has been returning all zeros and I can't figure out why. (file attached)

    I'm trying to say if the Fiscal Period is (x) and the agent is (y), what's the sum of sales? I see there are sales so I'm not sure why I'm getting all zeroes. Do you see what's wrong with my formula?

    Thanks

    Attached Files:

  2. vletm

    vletm Well-Known Member

    Messages:
    2,889
    Hayley
    RRFP
    is different than
    'space' RRFP 'space'
    > below, You have always 'space' before and after those three Agt.
    Screen Shot 2017-10-11 at 22.06.31.png
  3. Hayley

    Hayley Member

    Messages:
    39
    You know...I saw that solution in another post when I did a search but was positive I didn't have the same issue. Shame on me. Thank you very much...that was an easy fix.
  4. David Evans

    David Evans Active Member

    Messages:
    650
    Why don't you use the tools are that are built in to Excel for exactly this purpose, namely Tables and Pivot Tables? You might also consider using dates that Excel handles as such and then you'll be able to group them by Weeks, Months, Quarters or Years without having to manipulate them further.

    I've attached a file with an Example

    Attached Files:

  5. Hayley

    Hayley Member

    Messages:
    39
    Ooh that's a great idea. I always think of pivot tables as only being part of larger long-term, ongoing spreadsheets...I forget they can be used for simple one-off tasks like this too. Thank you!

Share This Page