Combine sales average between 3 stores

[louiesolo]

Hello,

I am trying to figure out how to add info from three spread sheets and get the average sales from each product. For instance, I have the sales of three different stores. I have combined all three of them into one and sorted by UPC for each product. I then did a Vlookup to identify the duplicate UPCs. It then identifies them and the column next to it gives me the sales number from each of the three stores from the same UPC. So what I am trying to do is combine the two or three same products that the store caries and average the units sold. What I'm having to do is manually go through each product and get the average but there are over 1100 items on my list so I am wondering if there is a formula in which will make it easier.

Thank you.

[alansidman]

here is how I would approach this. Highlight column B. Click on Sort and Filter--->Advanced. Check the unique box and select where you would like the results.

Then in an adjacent column to the unique codes, use the =Sumif function for each item. This will give you the total for each item. You can then average it in the next column.

[FDibbins]

I used this formula to run the average...
=IF(COUNTIF($B$2:B2,B2)>1,"",AVERAGEIF($B$2:$B$1116,B2,$D$2:$D$1116))

All you need to do now, is filter that column to exclude blanks, and you should have your list.

I also dont really see a need for what you have in col C?