problems w/ calculating average after inserting rows

D

debbz82

Hi~~
I am having problems with calculating certain numbers after i inser
a row. Right now, I am using =SUM(W3:W9)/ROWS(W3:W9) to calculate th
average of the 7 rows. When a insert a new row in between these
rows, the data is included in the sum and average. BUT, when i inser
a row after the original 7 rows, say after row 9, then the data in ro
10 is not included in the sum. Does anyone know how to write a formul
that add that data into my sum? I tried writing a macros for it but
am not that familiar w/ the syntax for it. Thanks!!

Debbi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamically sum rows 3
Selecting rows. 3
Calculating Growth % in a Pivot Table 1
Average function 5
Search and Combine Rows 4
always calculate last 5 rows even after 1 inserted 9
Arrays and Average 3
Average non-consecutive cells excluding zero 8

Top