August 11, 2019
I would like to seek your help in data selection based on a name range
I am working on a price list with 2 companies.
Both provide same products by different price.
I have named both as CompanyA and CompanyB. While their products are named the same - Product 1 - 5
My problem is if there is a way, when i select Company A, it uses only Comapny A range, and if i select Company B, it selects CompanyB Data.
See the attached
July 16, 2010
Welcome to our forum!
You need to structure your data in a Tabular layout. When you structure your data this way the formulas are easier because they work the way they were designed. In your example, you can use the SUMIFS function to return the price. See example attached.
Note: this will only work as long as there are no duplicate products in the list for each company. Otherwise you'll get the sum of those duplicates.