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.

Need help with sumif formula

Discussion in 'Ask an Excel Question' started by Hazra Hadee, Oct 9, 2018.

  1. Hazra Hadee

    Hazra Hadee Member

    Messages:
    38
    Hello,

    I have an excel sheet where expenses for internal divisions are tracked by their fund number, by GL, and by month. I have a file of raw data where all the division expenses are shown. I have one tab each set up for the individual divisions and trying to pull the information for that division from the raw data.

    The formula is tried to use was this
    =SUMIFS(tamt,gla,$A4,fnumber,$I$2,podate,">="&I$3,podate,"<"&J$3)
    But this just gives me zeros and not pulling any of the real information.

    What am I doing wrong? Thank you in advance

    Attached Files:

  2. Gayathri B S

    Gayathri B S New Member

    Messages:
    1
    Hello,

    Kindly check the file whether u r looking for the output what I have produced in the file

    Attached Files:

  3. sureshsonti

    sureshsonti Member

    Messages:
    102

    Please see attached

    Attached Files:

  4. sureshsonti

    sureshsonti Member

    Messages:
    102

    Please see attached. Had to make a change

    Attached Files:

Share This Page