Adding columns in tables with random blank cells

[Maxie]

How do I add a column of numbers that contain blank cells in between the cells with numbers? Holding the control key down and arrowing up doesn't work. Word 2003. Thanks

 

[DDM]

Maxie, one way is to specify in the formula the exact cells to add.
Remembering that the first cell in the table is A1, formulas that sum cells
in the second table column might look like this:

=SUM(B2:B8) -- where any of the cells in Column B, Rows 2-8 might be empty
or contain text;
=SUM(B2,B4,B6,B8) -- where Cells B3, B5, and B7 are empty, contain text, or
are to be excluded;
=SUM(B2:B4,B6:B8) -- where cell B5 is to be excluded.

Just enter the formula manually in the Formula field of the Table Formula
dialog box.
--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

How do I add a column of numbers that contain blank cells in between the

cells with numbers? Holding the control key down and arrowing up doesn't
work. Word 2003. Thanks

 

[Maxie]

Thanks .. it worked!

Maxie, one way is to specify in the formula the exact cells to add.
Remembering that the first cell in the table is A1, formulas that sum cells
in the second table column might look like this:

=SUM(B2:B8) -- where any of the cells in Column B, Rows 2-8 might be empty
or contain text;
=SUM(B2,B4,B6,B8) -- where Cells B3, B5, and B7 are empty, contain text, or
are to be excluded;
=SUM(B2:B4,B6:B8) -- where cell B5 is to be excluded.

Just enter the formula manually in the Formula field of the Table Formula
dialog box.
--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com


cells with numbers? Holding the control key down and arrowing up doesn't
work. Word 2003. Thanks