need vba code to group set of data by column A:A and sum and average of lenght of column

[manilara]

Dear sir

I want to group by Column A (i.e. Item) and Column N (i.e. length) and also want to add the sum total of each change in lengths of column E,F,G,H,I,J In the column K subtotal of E:J lenghts of column & want to add the average of L,M,N

Pls find the attachment what i looking for

 

[sijpie]

'dear sir' - what about the female programmers?

can you post an image of what you have and what you want somewhere and provide the links to the images here?

 

[manilara]

sir How to add image with this? Pls help

 

[sijpie]

post your image on some picture sharing site (google plus, whatever). The copy the link of that image and on this website click on the 'insert image' button above the reply box. Then paste the link. That's it.

 

[manilara]

Dear sir

Pls find the image this is what i looking for


https://www.dropbox.com/s/esw62651eia7njs/RESULT.jpg?dl=0

 

[sijpie]

why don't you do this with a pivot table? That is exactly what they are for.