Average calculation

[Rathish]

Hi,

I have a small situation and I am not able to find a workaround for that.
I would really be grateful if you could help me on the same.
The problem is that we are trying to calculate the average of 10 rows of a
table with the help of fields. I am enclosing a sample file as an attachment
for your reference.

In the first example, in Table 1, we have used cells B2 to B11 to calculate
the average in cell B12. The formula in cell B12 reads as “=Average(B2:B11)â€.
This formula correctly calculates the average value based on the cell
references given.
Now please see Table 2. In Table 2 we have deleted the Company 5 row. In
this case what word does is that it changes the cell references. So the
calculation cell which was B12 in table A is now referenced as B11 which
contains the formula “=Average(B2:B11)â€. So indirectly the average figure
present in the last row is being taken in the calculation itself because of
changes in the referencing.
Can you help us in solving this problem. Is there any work around available,
which will allow cell references to get updated when a row is being deleted
or if you have any other suggestion please let us know about the same.

Regards,

R.Radish Kumar

 

[John McGhie]

Hi Rathish:

The cure/work-around is "Don't do this with a Word table"

If you fiddle long enough, you will get it to work for this instance, by
editing the formula each time. But it will never be stable or reliable,
because Word table calculations do not have the facilities you need.

Instead, create a little Excel spreadsheet and embed it in the document.
You will not only get a stable and reliable solution, you will also get
accurate mathematics

Cheers

Hi,

I have a small situation and I am not able to find a workaround for that.
I would really be grateful if you could help me on the same.
The problem is that we are trying to calculate the average of 10 rows of a
table with the help of fields. I am enclosing a sample file as an attachment
for your reference.

In the first example, in Table 1, we have used cells B2 to B11 to calculate
the average in cell B12. The formula in cell B12 reads as ³=Average(B2:B11)².
This formula correctly calculates the average value based on the cell
references given.
Now please see Table 2. In Table 2 we have deleted the Company 5 row. In
this case what word does is that it changes the cell references. So the
calculation cell which was B12 in table A is now referenced as B11 which
contains the formula ³=Average(B2:B11)². So indirectly the average figure
present in the last row is being taken in the calculation itself because of
changes in the referencing.
Can you help us in solving this problem. Is there any work around available,
which will allow cell references to get updated when a row is being deleted
or if you have any other suggestion please let us know about the same.

Regards,

R.Radish Kumar

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Sydney, Australia. S33°53'34.20 E151°14'54.50
+61 4 1209 1410, mailto:[email protected]

 

[CyberTaz]

[un]Like John so diplomatically stated it, Word ain't a spreadsheet
program.

Instead of a Word table, click the button *next to* the table button to
insert a MS Excel Worksheet (or go to Insert> Object> MS Excel Worksheet
Object), take advantage of Excel's capabilities & from the standpoint of
appearance nobody will ever know the difference To make any future
changes just double-click the Excel table.