SUM refering to a second table is not working any more

[Bernhard]

Hello,

nice forum here.

I have a old Word .doc with some (2) macro in but it is not working any more.

The .doc contains 3 tables
1 tabel for header (Table 1)
1 table for product pricing (Table 2 named POSITIONEN)
name of prod., number of prod. and price per each
which is calculated to a price per line
1 table which grep the colume where the price per line is calculated and sum
it up

Table1 has 4 colums
Table2 has 6 colums
Table3 has 2 colums

The formula I use in Table3 B1 is:

=SUM(POSITIONEN f:f) \# "#.##0,00 €;(#.##0,00 €)


But all I get is

!Syntaxfehler, :

#####################

Thank you for your help.


Bernhard Stillger, Germany

 

[Jean-Guy Marcil]

Hello,

nice forum here.

I have a old Word .doc with some (2) macro in but it is not working any more.

The .doc contains 3 tables
1 tabel for header (Table 1)
1 table for product pricing (Table 2 named POSITIONEN)
name of prod., number of prod. and price per each
which is calculated to a price per line
1 table which grep the colume where the price per line is calculated and sum
it up

Table1 has 4 colums
Table2 has 6 colums
Table3 has 2 colums

The formula I use in Table3 B1 is:

=SUM(POSITIONEN f:f) \# "#.##0,00 €;(#.##0,00 €)

If it used to work and it doesn't anymore, I think you will agree that it
means something has changed.

Have you tried to change the formula?
Have you modified Table 2 in such a way that the bookmark is not where it
should be anymore?
Have you changed Office/Windows Version?
Have you changed the system language?