|In addition to Mike's suggestion of using AVERAGEIF, you might want to consider starting with a Filtered list of your items in a separate column so that you have a single instance of each item. This can be done using the Advanced Filter feature found on the Data ribbon and choosing the Unique Records Only option.|
You should then be able to use the AVERAGEIF function against that list, e.g.
where Column A contains your Items, Column C contains the Days and E2 contains the first item in your filtered list.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03