Summing cells in a column

J

Joanne

Hello,
I'm trying to use a formula to sum the cells in a column in a table. The
problem is that sometimes one or two of the cells will be empty and the SUM
function doesn't work then. Is there a switch or something similar that I
could add to the function that tells it to just skip a cell if it has no
value in it?

Thanks very much for any help.
 
J

Jean-Guy Marcil

Joanne said:
Hello,
I'm trying to use a formula to sum the cells in a column in a table. The
problem is that sometimes one or two of the cells will be empty and the SUM
function doesn't work then. Is there a switch or something similar that I
could add to the function that tells it to just skip a cell if it has no
value in it?
Click to expand...

On the following web page you will find a very good document (to download)
that has all kinds of tutorials for formulas in Word, including tables.
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Multiple IF Statement in Word 5
Cell data entering slow! 0
Pivot Table cell values 1
Word VBA - Automatic change content of a cell in table using dropdown list 5
Sum Values from different column 1
How to sum values into selection cells? 7
Two columns followed by single page-width column on same page 0

Top