Divide Total price by number of duplicates

[xKidz]

https://imgur.com/bh9WKg1

Hi,

In Column D i am counting all duplicates

In column AN i have the Cost

Column AP i am counting duplicate numbers from column D

What i would like to do is Calculate the Total cost by each occurrence in column D, and then divide the total cost by the count from column AP.

 

[Marcelo Branco]

Maybe

AR2 copied down
=SUMIF(D:D,D2,AN:AN)/AP2

M.

 

[xKidz]

Magic,

Thank you sir.