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

[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

 

[vbaInet]

Welcome to AWF manilara!

1. For the Sums and Averages (and everything else) create a Totals Query - look into that
2. For this, SUM OF SUBTOTAL(E:J), use the following in the Totals Query

Sum(Nz([Rep], 0) + Nz([Dealer], 0) + Nz([Vendor], 0) + Nz([Agent], 0) + Nz([Cold Call], 0) + Nz([Calls], 0))

... change the Totals row for this field to Expression

 

[manilara]

Sir can i have vba code? I little need of this I am not good in vba code i use to learn alot

 

[vbaInet]

There's no VBA code to give. The answers are in my post. Follow the instructions, do some research and work it out.