Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
autosum
Is there an autosum feature in Word 2007, similar to the "sigma" in Word 2003?
|
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autosum in a simple table | Tables | |||
how can I use autosum in a WORD table with blank cells | Tables |