How to Pass a Range to an Array Inside of a Sumif Function

[EdwardSnowden]

Hey everyone. I have a range of cells that are the names of 5 companies. I want to use a sumif with the criteria being that it will only sum if it is company 1, company 2, company 3, company 4, OR company 5. I know that the following would work:

Please Login or Register  to view this content.

The issue is that the companies to include in this sumif need to be changed often. Thus, I created another worksheet that has the list of companies to be used. Sadly, the following won't work:

Please Login or Register  to view this content.

How would I be able to reference a range such as 'Sheet2!$A$1:$A$5 in this formula?

[rorya]

Remove the curly brackets and array enter the formula using Ctrl+Shift+Enter. Also note that with SUMIF, the sum range is the last range, not the first one, unlike with SUMIFS.

[EdwardSnowden]

Thank you Rorya! That solved my question.