sum up column value in a table

Hi All,

If there is a table.

1st row contain three column. with data 0,0,3 (each value in each cell)
2nd row contain four column where the 2nd and 3rd column are 50% width of
1st row 2nd column. And the data is 0,0,30,40 (each value in each cell)
3rd .. nth row, each width same as 1st row without data

The problem which I face is, if I need to to put total in 5th row,

{=sum(C1:C4) \#,###,###.00 \* MERGEFORMAT}

the MSword will give out: 33 (3+30)

instead of 43 (3+40) which I expected to have.

Is there any way to sum up with Macro with a (some) smarter way?


Thanks for advice ~

Doug
Tue May 03 13:24:16 CDT 2005

I would suggest that 33 is the result to be expected from adding the values
entered into the 3rd cell in each row (which is what column C is.

To get 43 you would need to use {= C1 + D2 }

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"VBALover" <Vbalover@noemail.com> wrote in message
news:uMrKrH%23TFHA.3140@TK2MSFTNGP14.phx.gbl...
>
> Hi All,
>
> If there is a table.
>
> 1st row contain three column. with data 0,0,3 (each value in each cell)
> 2nd row contain four column where the 2nd and 3rd column are 50% width of
> 1st row 2nd column. And the data is 0,0,30,40 (each value in each cell)
> 3rd .. nth row, each width same as 1st row without data
>
> The problem which I face is, if I need to to put total in 5th row,
>
> {=sum(C1:C4) \#,###,###.00 \* MERGEFORMAT}
>
> the MSword will give out: 33 (3+30)
>
> instead of 43 (3+40) which I expected to have.
>
> Is there any way to sum up with Macro with a (some) smarter way?
>
>
> Thanks for advice ~
>
>

Ian
Tue May 03 22:51:09 CDT 2005

An alternate method is to select the column and use ToolsCalculate (a Word
Command).
This puts the result in the clipboard from where you can paste result.
One other advantage with tools calculate, it copes with blank cells, which
sum(??) will not.
~~~~
Selection.SelectColumn
Application.Run MacroName:="ToolsCalculate"
~~~~

HTH

Ian B

"VBALover" <Vbalover@noemail.com> wrote in message
news:uMrKrH#TFHA.3140@TK2MSFTNGP14.phx.gbl...
>
> Hi All,
>
> If there is a table.
>
> 1st row contain three column. with data 0,0,3 (each value in each cell)
> 2nd row contain four column where the 2nd and 3rd column are 50% width of
> 1st row 2nd column. And the data is 0,0,30,40 (each value in each cell)
> 3rd .. nth row, each width same as 1st row without data
>
> The problem which I face is, if I need to to put total in 5th row,
>
> {=sum(C1:C4) \#,###,###.00 \* MERGEFORMAT}
>
> the MSword will give out: 33 (3+30)
>
> instead of 43 (3+40) which I expected to have.
>
> Is there any way to sum up with Macro with a (some) smarter way?
>
>
> Thanks for advice ~
>
>

VBALover
Wed May 04 09:02:42 CDT 2005

Which version of word you are using with command ToolsCalculate?
I am using Word97 which do not have such command.

Thanks for advice


"Ian B" <ian@docspro.co.nz> ¦b¶l¥ó
news:uxrVWyFUFHA.2056@tk2msftngp13.phx.gbl ¤¤¼¶¼g...
> An alternate method is to select the column and use ToolsCalculate (a Word
> Command).
> This puts the result in the clipboard from where you can paste result.
> One other advantage with tools calculate, it copes with blank cells, which
> sum(??) will not.
> ~~~~
> Selection.SelectColumn
> Application.Run MacroName:="ToolsCalculate"
> ~~~~
>
> HTH
>
> Ian B
>
> "VBALover" <Vbalover@noemail.com> wrote in message
> news:uMrKrH#TFHA.3140@TK2MSFTNGP14.phx.gbl...
> >
> > Hi All,
> >
> > If there is a table.
> >
> > 1st row contain three column. with data 0,0,3 (each value in each cell)
> > 2nd row contain four column where the 2nd and 3rd column are 50% width
of
> > 1st row 2nd column. And the data is 0,0,30,40 (each value in each cell)
> > 3rd .. nth row, each width same as 1st row without data
> >
> > The problem which I face is, if I need to to put total in 5th row,
> >
> > {=sum(C1:C4) \#,###,###.00 \* MERGEFORMAT}
> >
> > the MSword will give out: 33 (3+30)
> >
> > instead of 43 (3+40) which I expected to have.
> >
> > Is there any way to sum up with Macro with a (some) smarter way?
> >
> >
> > Thanks for advice ~
> >
> >
>
>

Ian
Thu May 05 20:08:10 CDT 2005

Word 97 has it.
To find command, go to - Tools - macro - macros. Select in the dropdown
"Macros in" Word commands - scroll down to ToolsCalculate and run it.
This is obviously a manual "calculate".
To automate it use the VBA command
Application.Run MacroName:="ToolsCalculate"

Regardless of VBA its a very handy item to drag onto tool bar for every day
use in doing calculations.
Follows normal conventions ie (1000/12 + (3-2)) Highlight the calculation,
press tools calculate and there is the answer (84.33) on the clipboard and
displayed on the bar at bottom of screen. (fogotten its offical name)

HTH

Ian B

"VBALover" <Vbalover@noemail.com> wrote in message
news:eI4HDELUFHA.3140@TK2MSFTNGP14.phx.gbl...
> Which version of word you are using with command ToolsCalculate?
> I am using Word97 which do not have such command.
>
> Thanks for advice
>
>
> "Ian B" <ian@docspro.co.nz> ¦b¶l¥ó
> news:uxrVWyFUFHA.2056@tk2msftngp13.phx.gbl ¤¤¼¶¼g...
> > An alternate method is to select the column and use ToolsCalculate (a
Word
> > Command).
> > This puts the result in the clipboard from where you can paste result.
> > One other advantage with tools calculate, it copes with blank cells,
which
> > sum(??) will not.
> > ~~~~
> > Selection.SelectColumn
> > Application.Run MacroName:="ToolsCalculate"
> > ~~~~
> >
> > HTH
> >
> > Ian B
> >
> > "VBALover" <Vbalover@noemail.com> wrote in message
> > news:uMrKrH#TFHA.3140@TK2MSFTNGP14.phx.gbl...
> > >
> > > Hi All,
> > >
> > > If there is a table.
> > >
> > > 1st row contain three column. with data 0,0,3 (each value in each
cell)
> > > 2nd row contain four column where the 2nd and 3rd column are 50% width
> of
> > > 1st row 2nd column. And the data is 0,0,30,40 (each value in each
cell)
> > > 3rd .. nth row, each width same as 1st row without data
> > >
> > > The problem which I face is, if I need to to put total in 5th row,
> > >
> > > {=sum(C1:C4) \#,###,###.00 \* MERGEFORMAT}
> > >
> > > the MSword will give out: 33 (3+30)
> > >
> > > instead of 43 (3+40) which I expected to have.
> > >
> > > Is there any way to sum up with Macro with a (some) smarter way?
> > >
> > >
> > > Thanks for advice ~
> > >
> > >
> >
> >
>
>