macros for calculating a new average after inserting a new row

[debbz82]

I was wondering if anyone could help me with this ~~
I am working on a spreadsheet and I need to come up with a macro
that will check all the number in the cells of Column B, so basicall
checking row by row. If the number in the cells match, I need to tak
the data from the W cell of that row, and keep a running total of th
data in the W cell. All at the same time, I need to keep a count o
how many cells in Column B have the same number, so that I can divid
the running total by this number to find the average score of all thes
cells.

For example:

Column B Column W
101 3
101 3
101 6
102 7

In this case, the first 3 rows have the same number for column B. Sinc
they are the same, I need to add the numbers in Column W of those row
together , so 3+3+6. Then, since I have counted 3 rows, to find th
average I need to divide 3+3+6 by 3.

Thanks =

 

[debbz82]

Sorry!! I forgot something. I have found a formula that solves m
previous question, BUT my problem now is, if I insert a new row, how d
I change my formula so that it still does the same thing? I'm usin
=SUM(w3:w9)/Rows(W3:W9) to sum the rows and divide by the number o
rows. But, if i insert a new row, the formula doesn't add the value o
the new row into it. Help!

 

[Don Guillett]

try
=average(W:W)