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.

Help with SUMIFs Please

Discussion in 'Ask an Excel Question' started by keasha, Mar 14, 2019.

  1. keasha

    keasha New Member

    Messages:
    24
    Hello there

    Hoping someone can help me with SUMIFS for multiple criteria. I have added a workbook attached.

    I am not sure how to write the formula.

    In the first tab is the data to be returned (by team, classification ,FTE and $$)

    in the second tab is the data

    any help would be greatly appreciated.

    Attached Files:

  2. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    984
    This perhaps?

    Attached Files:

  3. jayalaxmi

    jayalaxmi Active Member

    Messages:
    249
    Hi

    You can use sumproduct for the same as an another alternative:)

    Thanks
    Jaya S

    Attached Files:

  4. Peter Bartholomew

    Peter Bartholomew Well-Known Member

    Messages:
    709
    It would appear that you have some serious data integrity issues.

    p.s I have used array formulas to pick up the filter criteria because of their simplicity. It is possible to use relative referencing instead.

    Attached Files:

  5. Peter Bartholomew

    Peter Bartholomew Well-Known Member

    Messages:
    709
    I have just reimported my file to a machine with Excel 365 insider loaded to take the solution through modern Dynamic Arrays. It really is a gem when applied to problems of this kind. There is just one formula in the top left cell of each block and the criteria ranges can be generated from the source data using UNIQUE. Many data issues show up at this stage with lists that contain 'near duplicates' or other unanticipated values.

    All of the traditional spreadsheet junk like relative referencing and 'copy down' goes into the trash can where it belongs :DD {evil grin}!
  6. keasha

    keasha New Member

    Messages:
    24
    thanks Peter. all i am doing is trying to learn.i am most certainly not an expert just been tasked with something i have been wrestling with trying to do based on the data i have. thanks for your help its greatly appreciated.
  7. Peter Bartholomew

    Peter Bartholomew Well-Known Member

    Messages:
    709
    @keasha
    That is understood. My post #5 wasn't aimed at you; I know the approaches I take are not mainstream. You do what you can and we are here to support.

Share This Page