help in summation

[ikaranverma]

hi,
thanks in advance,
and pardon me for my english,

i am trying to make an excel sheet to keep my inventory of my company

i have a large no of products, here,

what i m trying to do is

>>i have a sheet(diamond) which has details of the diamonds where i have shape, size, weight, price rate

>>then there is another sheet RINGS, which i will be using to enter details of all my rings,

in the details i have to enter the shape of the ring which i can choose from a drop down list, corresponding to which i will have to choose the size and enter the count,​

any one product can have any different shapes or sizes or count of diamonds

then i want to calculate the summation price and count for each shapes of diamond(NOT FOR EACH SIZE),which can be calculated from the chart

this is what i have done untill now,

now i am stuck here, i dont knw how to calculate summation price and count for each shapes of diamond

F4=IF(F4="",DSHAPES,INDEX(diamondshapes,MATCH($F$4,diamondsize,0)))
G4=OFFSET(diamondstart,MATCH(F4,diamondshapes,0)-1,1,COUNTIF(diamondshapes,F4),1)

here is the file https://www.dropbox.com/s/62ill40am5n2mvo/FINAL EXCEL.xlsx?dl=0 https://www.dropbox.com/s/62ill40am5n2mvo/FINAL EXCEL.xlsx?dl=0