# Cross worksheet average sales of unique names

Status
Not open for further replies.

#### Kalemaroni

##### New Member
I have 2 worksheets. Worksheet 1 has the name of the products sold and unique products column as well as Transaction ID. Worksheet 2 has the Sales and a Transaction ID that is the same as Worksheet1's Transaction ID.

I'm looking for a formula that will display the Average Sales of the Unique Product Names listed in Column C of Worksheet1 into column D of Worksheet1.

Expected value of Worksheet1!D1 is 15 ((10 + 20) / 2) and Worksheet1!D2 and D3 are 10

Worksheet1

 Product Transaction ID Unique Product Name Average Sales of Unique Product Name A B C D Apples 1 Apples =??? Apples 2 Carrots =??? Onions 3 Onions =??? Carrots 4

Worksheet2

 Transaction ID Sales A B 1 10 2 20 3 10 4 10

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### Fluff

##### MrExcel MVP, Moderator
Duplicate Cross worksheet average sales of unique products

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Status
Not open for further replies.

Replies
1
Views
51
Replies
3
Views
188
Replies
1
Views
76
Replies
1
Views
211
Replies
3
Views
79