Average if cells are duplicates

Hi,

I have data based on zipcodes and these zipcodes fall into larger area codes. I would like to have this data as an average for each area. Basically I want all my data in new columns if areacodes match. I already have a seperate column for all the unique areacode used in my research. Presumably I would use the 'averageif' function but I do not know how to write that I want duplicates to average as a criterea. In the attachment I have made an example of what I need. What is the best way to get this average data in column 'H' and 'I' in my example?

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

How are you defining 'duplicates'? I see no duplicates in your sample.

Maybe in H2 copied across and down?

=AVERAGEIFS(C$2:C$10,$B$2:$B$10,$G2)

Or, for your locale:

=AVERAGEIFS(C$2:C$10;$B$2:$B$10;$G2)

So what was wrong with my suggestion, then? Did you try it?

Those are not duplicates, really - duplicates would be rows (records) where all columns (fields) were the same.

If my suggestion doesn't work for you, attach a workbook showing the issue.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.