#1   Report Post  
Posted to microsoft.public.word.tables
alexm alexm is offline
external usenet poster
 
Posts: 2
Default autosum

Is there an autosum feature in Word 2007, similar to the "sigma" in Word 2003?
  #2   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default autosum

Perhaps not as versatile, but from the Tables menu, select Formula. If you
do that in a cell that is immediately below other cells that all contain
values, the default formula that it will want to insert is =Sum(Above)

--
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

"alexm" wrote in message
...
Is there an autosum feature in Word 2007, similar to the "sigma" in Word
2003?



  #3   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default autosum

There is actually an AutoSum command in Word (I think it runs the Sum(Above)
formula by default). You can add it to your toolbar, and it has a capital
sigma icon. Find it in the Table commands category in Tools | Customize.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Doug Robbins - Word MVP" wrote in message
...
Perhaps not as versatile, but from the Tables menu, select Formula. If

you
do that in a cell that is immediately below other cells that all contain
values, the default formula that it will want to insert is =Sum(Above)

--
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

"alexm" wrote in message
...
Is there an autosum feature in Word 2007, similar to the "sigma" in Word
2003?




  #4   Report Post  
Posted to microsoft.public.word.tables
alexm alexm is offline
external usenet poster
 
Posts: 2
Default autosum

I couldn't find the Sigma command in Word 2007 (it does existi in Word 2003).

I did find the formula function, though. It is in Table Tools, layout. For
me at least, theres a real learning curve in switching from 2003 to 2007!
If I invoke the formula button, it does by default select the =sum(above)
formula. It's more clicks than Word 2003, but it does work.

Thanks to all!



"alexm" wrote:

Is there an autosum feature in Word 2007, similar to the "sigma" in Word 2003?

  #5   Report Post  
Posted to microsoft.public.word.tables
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 77
Default autosum

Yes. You can use =sum(above).

If you want to sum different cells in a column, then you have to treat the
table similar to excel column heading. For example, if I have three columns
and three rows, Then I will assume similar to excel and type : =sum(A1,C3).
This will give you sum total of cell A1+C3. You tables in Word is similar to
Excel column heading.

Challa Prabhu

"alexm" wrote:

Is there an autosum feature in Word 2007, similar to the "sigma" in Word 2003?



  #6   Report Post  
Posted to microsoft.public.word.tables
Kurt Kurt is offline
external usenet poster
 
Posts: 20
Default autosum

This didn't work for me. It just put in the character string =sum(C2,C8) but
didn't add the values.

"challa prabhu" wrote:

Yes. You can use =sum(above).

If you want to sum different cells in a column, then you have to treat the
table similar to excel column heading. For example, if I have three columns
and three rows, Then I will assume similar to excel and type : =sum(A1,C3).
This will give you sum total of cell A1+C3. You tables in Word is similar to
Excel column heading.

Challa Prabhu

"alexm" wrote:

Is there an autosum feature in Word 2007, similar to the "sigma" in Word 2003?

  #7   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default autosum

Did you type this in the Table | Formula dialog? Or did you insert it as a
field, after pressing Ctrl+F9?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Kurt" wrote in message
...
This didn't work for me. It just put in the character string =sum(C2,C8)

but
didn't add the values.

"challa prabhu" wrote:

Yes. You can use =sum(above).

If you want to sum different cells in a column, then you have to treat

the
table similar to excel column heading. For example, if I have three

columns
and three rows, Then I will assume similar to excel and type :

=sum(A1,C3).
This will give you sum total of cell A1+C3. You tables in Word is

similar to
Excel column heading.

Challa Prabhu

"alexm" wrote:

Is there an autosum feature in Word 2007, similar to the "sigma" in

Word 2003?

  #8   Report Post  
Posted to microsoft.public.word.tables
Kurt Kurt is offline
external usenet poster
 
Posts: 20
Default autosum

I just typed it in the field. I subsequently found an ability to insert it
somewhere in the Table Tools menu, I believe in Layout.

"Suzanne S. Barnhill" wrote:

Did you type this in the Table | Formula dialog? Or did you insert it as a
field, after pressing Ctrl+F9?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Kurt" wrote in message
...
This didn't work for me. It just put in the character string =sum(C2,C8)

but
didn't add the values.

"challa prabhu" wrote:

Yes. You can use =sum(above).

If you want to sum different cells in a column, then you have to treat

the
table similar to excel column heading. For example, if I have three

columns
and three rows, Then I will assume similar to excel and type :

=sum(A1,C3).
This will give you sum total of cell A1+C3. You tables in Word is

similar to
Excel column heading.

Challa Prabhu

"alexm" wrote:

Is there an autosum feature in Word 2007, similar to the "sigma" in

Word 2003?


  #9   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default autosum

Table | Formula allows you to type the contents of the field; if you want to
insert the field manually, you can use Insert | Field, or you can press
Ctrl+F9 to insert the field braces and then type the text between them.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Kurt" wrote in message
...
I just typed it in the field. I subsequently found an ability to insert

it
somewhere in the Table Tools menu, I believe in Layout.

"Suzanne S. Barnhill" wrote:

Did you type this in the Table | Formula dialog? Or did you insert it as

a
field, after pressing Ctrl+F9?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"Kurt" wrote in message
...
This didn't work for me. It just put in the character string

=sum(C2,C8)
but
didn't add the values.

"challa prabhu" wrote:

Yes. You can use =sum(above).

If you want to sum different cells in a column, then you have to

treat
the
table similar to excel column heading. For example, if I have three

columns
and three rows, Then I will assume similar to excel and type :

=sum(A1,C3).
This will give you sum total of cell A1+C3. You tables in Word is

similar to
Excel column heading.

Challa Prabhu

"alexm" wrote:

Is there an autosum feature in Word 2007, similar to the "sigma"

in
Word 2003?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Autosum in a simple table Marcel Vreuls Tables 2 May 31st 06 05:15 PM
how can I use autosum in a WORD table with blank cells Jennifer from DPI Tables 4 November 11th 04 08:30 AM


All times are GMT +1. The time now is 10:21 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"