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:
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:
How would I be able to reference a range such as 'Sheet2!$A$1:$A$5 in this formula?
Bookmarks