Reply
 
Thread Tools Display Modes
  #1   Report Post  
Jennifer from DPI
 
Posts: n/a
Default how can I use autosum in a WORD table with blank cells

I'm trying to add up a column in a word table. There are blank cells in the
column and the autosum will not add up correctly unless there is a numerical
figure in all cells. I don't want to put a zero in the blank cells.

is there a way to still use autosum with blank cells?

(I don't want to use Excel either)


  #3   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

Apparently Word is able to get a correct sum even with empty cells in the
range in Word 2003. I was surprised to note this in my invoice form;
normally I delete the unused rows, but I was keeping them open to keep a
running total for a client for whom I had not set up an account.

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

"Jezebel" wrote in message
...
You could put zero in the cells and format them as hidden. Word's table
calculations are minimal at best.


"Jennifer from DPI" Jennifer from wrote in
message ...
I'm trying to add up a column in a word table. There are blank cells in

the
column and the autosum will not add up correctly unless there is a

numerical
figure in all cells. I don't want to put a zero in the blank cells.

is there a way to still use autosum with blank cells?

(I don't want to use Excel either)





  #4   Report Post  
Jezebel
 
Posts: n/a
Default

This must be an improvement with W2003. W2000 stops at an empty cell -- rows
above that are ignored.


"Suzanne S. Barnhill" wrote in message
...
Apparently Word is able to get a correct sum even with empty cells in the
range in Word 2003. I was surprised to note this in my invoice form;
normally I delete the unused rows, but I was keeping them open to keep a
running total for a client for whom I had not set up an account.

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

"Jezebel" wrote in message
...
You could put zero in the cells and format them as hidden. Word's table
calculations are minimal at best.


"Jennifer from DPI" Jennifer from wrote

in
message ...
I'm trying to add up a column in a word table. There are blank cells

in
the
column and the autosum will not add up correctly unless there is a

numerical
figure in all cells. I don't want to put a zero in the blank cells.

is there a way to still use autosum with blank cells?

(I don't want to use Excel either)







  #5   Report Post  
macropod
 
Posts: n/a
Default

Hi Jennifer,

In your 'total' row, press Ctrl-F9 to create a pair of field braces '{ }'

Between the field braces type '=SUM(A1:A10)', where 'A' represents the
column (as in Excel) and the 1 & 10 represent the first and last rows to be
added (as in Excel), so that your field looks like:
{=SUM(A1:A10)}

Then press F9 to update.

Cheers


"Jennifer from DPI" Jennifer from wrote in
message ...
I'm trying to add up a column in a word table. There are blank cells in

the
column and the autosum will not add up correctly unless there is a

numerical
figure in all cells. I don't want to put a zero in the blank cells.

is there a way to still use autosum with blank cells?

(I don't want to use Excel either)




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 1/11/2004


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
In typing dates in Word, i.e. "January 12" how do you keep the "1. Carol Microsoft Word Help 2 January 12th 05 08:09 PM
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 10:50 PM
WP Delay Code - Word Equiv Mike G - Milw, WI Microsoft Word Help 6 January 10th 05 04:12 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM
Why do I get a large blank space within my Word table? Todd F. Tables 1 November 4th 04 07:05 PM


All times are GMT +1. The time now is 11:07 PM.

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

About Us

"It's about Microsoft Word"