[Rickh957]

[Suzanne S. Barnhill]

After you have created a table, you will have two contextual table tabs:
Design and Layout. On the Layout tab, in the Data group, there is a Formula
button that opens the Formula dialog, where you can select the Sum function.
If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum
button, you'll have to type this in yourself.

Not quite the answer you wanted, is it? So click on the arrow at the end of
the QAT, choose More Commands..., select Commands Not in the Ribbon, scroll
down to Sum, and click Add .

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Rickh957" wrote in message
...

[Graham Mayor]

Suzanne S. Barnhill wrote:
If you want it to be Sum(Above) or
Sum(Left), as created by the AutoSum button, you'll have to type this
in yourself.

Word will offer Sum(Above) or Sum(Left) as the default choice for the
autosum button if there is an unambiguous choice of numbers to the left or
above.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org

[Suzanne S. Barnhill]

You didn't read the whole reply, did you? Yes, the AutoSum button will do
this. My point was that the Formula dialog doesn't: it doesn't replicate the
behavior of the AutoSum button and consequently is a very inefficient
substitute.

My reply explained how to insert a Sum(Above) or Sum(Left) field in Word
2007 (where the AutoSum button is not, by default, available); it then
explained how to add the AutoSum button to the QAT.

For the benefit of others who may be coming in late, here's the whole
message:

"After you have created a table, you will have two contextual table tabs:
Design and Layout. On the Layout tab, in the Data group, there is a Formula
button that opens the Formula dialog, where you can select the Sum function.
If you want it to be Sum(Above) or Sum(Left), as created by the AutoSum
button, you'll have to type this in yourself.

"Not quite the answer you wanted, is it? So click on the arrow at the end of
the QAT, choose More Commands..., select Commands Not in the Ribbon, scroll
down to Sum, and click Add ."

I should probably have preface this by saying: "Word 2007 doesn't have an
AutoSum button by default; the procedure that replaces it is quite tedious."

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Graham Mayor" wrote in message
...
Suzanne S. Barnhill wrote:
If you want it to be Sum(Above) or
Sum(Left), as created by the AutoSum button, you'll have to type this
in yourself.

Word will offer Sum(Above) or Sum(Left) as the default choice for the
autosum button if there is an unambiguous choice of numbers to the left or
above.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org

[Graham Mayor]

I had read your reply. The point of my response was that the *formula*
button *does* offer Sum(Above) or Sum(Left) as the default entry, if there
is content in the row or the column adjacent to where you wish to place the
formula. What it doesn't do (which the autosum button does) is enter the
formula directly iunto the table ie you need two clicks to the autosum
button's one. In the whole scheme of things I didn't feel that two clicks
instead of one amounted to 'quite tedious', but each to his own

You don't have to type in the formula dialog unless the table is empty.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Suzanne S. Barnhill wrote:
You didn't read the whole reply, did you? Yes, the AutoSum button
will do this. My point was that the Formula dialog doesn't: it
doesn't replicate the behavior of the AutoSum button and consequently
is a very inefficient substitute.

My reply explained how to insert a Sum(Above) or Sum(Left) field in
Word 2007 (where the AutoSum button is not, by default, available);
it then explained how to add the AutoSum button to the QAT.

For the benefit of others who may be coming in late, here's the whole
message:

"After you have created a table, you will have two contextual table
tabs: Design and Layout. On the Layout tab, in the Data group, there
is a Formula button that opens the Formula dialog, where you can
select the Sum function. If you want it to be Sum(Above) or
Sum(Left), as created by the AutoSum button, you'll have to type this
in yourself.
"Not quite the answer you wanted, is it? So click on the arrow at the
end of the QAT, choose More Commands..., select Commands Not in the
Ribbon, scroll down to Sum, and click Add ."

I should probably have preface this by saying: "Word 2007 doesn't
have an AutoSum button by default; the procedure that replaces it is
quite tedious."

"Graham Mayor" wrote in message
...
Suzanne S. Barnhill wrote:
If you want it to be Sum(Above) or
Sum(Left), as created by the AutoSum button, you'll have to type
this in yourself.

Word will offer Sum(Above) or Sum(Left) as the default choice for the
autosum button if there is an unambiguous choice of numbers to the
left or above.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org

[Suzanne S. Barnhill]

Ah, okay, I confess I was trying it with an empty table, just to find where
the commands were. Having now tried it with numbers in the cells, I see that
SUM(ABOVE) is offered as the default formula. My apologies.

OTOH, it actually requires three clicks in some instances. If you have just
inserted a table and typed in it, the Table Tools | Design tab is on top.
You have to select the Layout tab before you can access the Formula button,
then click to insert the formula. If you use AutoSum a lot, it might be
worth a button on the QAT to save a couple of clicks.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Graham Mayor" wrote in message
...
I had read your reply. The point of my response was that the *formula*
button *does* offer Sum(Above) or Sum(Left) as the default entry, if there
is content in the row or the column adjacent to where you wish to place the
formula. What it doesn't do (which the autosum button does) is enter the
formula directly iunto the table ie you need two clicks to the autosum
button's one. In the whole scheme of things I didn't feel that two clicks
instead of one amounted to 'quite tedious', but each to his own

You don't have to type in the formula dialog unless the table is empty.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Suzanne S. Barnhill wrote:
You didn't read the whole reply, did you? Yes, the AutoSum button
will do this. My point was that the Formula dialog doesn't: it
doesn't replicate the behavior of the AutoSum button and consequently
is a very inefficient substitute.

My reply explained how to insert a Sum(Above) or Sum(Left) field in
Word 2007 (where the AutoSum button is not, by default, available);
it then explained how to add the AutoSum button to the QAT.

For the benefit of others who may be coming in late, here's the whole
message:

"After you have created a table, you will have two contextual table
tabs: Design and Layout. On the Layout tab, in the Data group, there
is a Formula button that opens the Formula dialog, where you can
select the Sum function. If you want it to be Sum(Above) or
Sum(Left), as created by the AutoSum button, you'll have to type this
in yourself.
"Not quite the answer you wanted, is it? So click on the arrow at the
end of the QAT, choose More Commands..., select Commands Not in the
Ribbon, scroll down to Sum, and click Add ."

I should probably have preface this by saying: "Word 2007 doesn't
have an AutoSum button by default; the procedure that replaces it is
quite tedious."

"Graham Mayor" wrote in message
...
Suzanne S. Barnhill wrote:
If you want it to be Sum(Above) or
Sum(Left), as created by the AutoSum button, you'll have to type
this in yourself.

Word will offer Sum(Above) or Sum(Left) as the default choice for the
autosum button if there is an unambiguous choice of numbers to the
left or above.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org