Hi,
In Row A, let's say I have a either of the listed:
Company A
Company B
Company C
Company D
In Row B, let's say I have a either of the listed:
Product 1
Product 2
Product 3
Product 4
In Row C, I have a bunch of random prices listed.
How can I create a formula where I want the average of both Company A OR Company B for Product 1? I want one average price no matter if it is company A or B, for Product 1. How do I do that?? THANKS!!! I am gonna want average for combinations of companies and products, the actual data is 12 deep on companies and 13 on products.
In Row A, let's say I have a either of the listed:
Company A
Company B
Company C
Company D
In Row B, let's say I have a either of the listed:
Product 1
Product 2
Product 3
Product 4
In Row C, I have a bunch of random prices listed.
How can I create a formula where I want the average of both Company A OR Company B for Product 1? I want one average price no matter if it is company A or B, for Product 1. How do I do that?? THANKS!!! I am gonna want average for combinations of companies and products, the actual data is 12 deep on companies and 13 on products.
Last edited: