G
Guest
Hi,
My Excel 2000 spreadsheet looks something like this:
Product Location Customer Units Revenue Weighted Average
Apples New York Customer 1 20 $100
Apples New York Customer 2 41 $180
Apples New York Customer 3 3 $33 xxx
Apples Los Angeles etc... etc... etc.
Apples Los Angeles
Apples Los Angeles xxx
Oranges New York
Oranges New York xxx
Oranges Seattle
Oranges Seattle xxx
Peaches Seattle xxx
Oranges San Fran xxx
Does anyone have a formula that I can copy straight down in the "weighted average column" that will recognize when to calculate the weighted average revenue of a particlar product by in a particular market.
For example, the first instance of "xxx" should show the weighted average revenue of apples in New York. The second instance of "xxx" should show the weighted average revenue of apples in Los Angeles. The third instance of "xxx" should show the weighted average revenue of oranges in New York.
My actual spreadhseet is about 2000 rows and has about 20 different markets and 10 different products.
Thanks so much for your help in advance. I really appreciate all the time and help you excel geniuses have provided.
My Excel 2000 spreadsheet looks something like this:
Product Location Customer Units Revenue Weighted Average
Apples New York Customer 1 20 $100
Apples New York Customer 2 41 $180
Apples New York Customer 3 3 $33 xxx
Apples Los Angeles etc... etc... etc.
Apples Los Angeles
Apples Los Angeles xxx
Oranges New York
Oranges New York xxx
Oranges Seattle
Oranges Seattle xxx
Peaches Seattle xxx
Oranges San Fran xxx
Does anyone have a formula that I can copy straight down in the "weighted average column" that will recognize when to calculate the weighted average revenue of a particlar product by in a particular market.
For example, the first instance of "xxx" should show the weighted average revenue of apples in New York. The second instance of "xxx" should show the weighted average revenue of apples in Los Angeles. The third instance of "xxx" should show the weighted average revenue of oranges in New York.
My actual spreadhseet is about 2000 rows and has about 20 different markets and 10 different products.
Thanks so much for your help in advance. I really appreciate all the time and help you excel geniuses have provided.