macros for calculating a new average after inserting a new row
 

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 =

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

macros for calculating a new average after inserting a new row
 

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!

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

macros for calculating a new average after inserting a new row
 

try
=average(W:W)

--
Don Guillett
SalesAid Software

"debbz82" wrote in message
...

I was wondering if anyone could help me with this ~~
I am working on a spreadsheet and I need to come up with a macros
that will check all the number in the cells of Column B, so basically
checking row by row. If the number in the cells match, I need to take
the data from the W cell of that row, and keep a running total of the
data in the W cell. All at the same time, I need to keep a count of
how many cells in Column B have the same number, so that I can divide
the running total by this number to find the average score of all these
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. Since
they are the same, I need to add the numbers in Column W of those rows
together , so 3+3+6. Then, since I have counted 3 rows, to find the
average I need to divide 3+3+6 by 3.

Thanks =)


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/