Adding columns in tables with random blank cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Maxie said:
How do I add a column of numbers that contain blank cells in between the
Click to expand...
cells with numbers? Holding the control key down and arrowing up doesn't
work. Word 2003. Thanks
 
Thanks .. it worked!

DDM said:
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
Click to expand...
 
Back
Top