Formula to add

I want to be able to add a column of figures, but in several cells they will
be blanc. I have found that the autosum only works if there are numbers in
each cell. In this particular document I have subtotals in the right hand
column that I want to total at the end with probably 4 or 5 blanc cells in
between each sub total. To put a formula saying D1+D8+D20 etc and having to
count down to know the cells to put in the formula, you may as well use a
calculator. Is there any formula you can put that would add all above
without having to put a zero in the blanc cells. Could anyone help please.

Margaret

Bonjour,

Dans son message, Margaret Upton écrivait :
In this message, Margaret Upton wrote:

|| I want to be able to add a column of figures, but in several cells they
will
|| be blanc. I have found that the autosum only works if there are numbers
in
|| each cell. In this particular document I have subtotals in the right
hand
|| column that I want to total at the end with probably 4 or 5 blanc cells
in
|| between each sub total. To put a formula saying D1+D8+D20 etc and having
to
|| count down to know the cells to put in the formula, you may as well use a
|| calculator. Is there any formula you can put that would add all above
|| without having to put a zero in the blanc cells. Could anyone help
please.
||

You could try giving your sub-totals bookmark names (Insert Bookmark).
Then use those names in the formula:
=(Sub1 + Sub2 = Sub3) etc.
or
=SUM(Sub1, Sub2, Sub3)

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org

Hi Margaret,

Assuming you know how many rows there are to sum, you could use a formula
like:
=SUM(D120)
which won't be affected by blank cells. To do this, select the 'total' cell
in column D, press Shift-F9 to create a pair of field braces and type the
formula between them. Then press F9 to update the field.

For more information on Word field maths, see:
http://www.wopr.com/cgi-bin/w3t/show...&Number=365442

Cheers


"Margaret Upton" wrote in message
...
I want to be able to add a column of figures, but in several cells they
will
be blanc. I have found that the autosum only works if there are numbers
in
each cell. In this particular document I have subtotals in the right hand
column that I want to total at the end with probably 4 or 5 blanc cells in
between each sub total. To put a formula saying D1+D8+D20 etc and having
to
count down to know the cells to put in the formula, you may as well use a
calculator. Is there any formula you can put that would add all above
without having to put a zero in the blanc cells. Could anyone help
please.

Margaret





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.684 / Virus Database: 446 - Release Date: 13/05/2004

Jean

Thank you very much will try that.

Margaret

"Jean-Guy Marcil" wrote in message
...
Bonjour,

Dans son message, Margaret Upton écrivait :
In this message, Margaret Upton wrote:

|| I want to be able to add a column of figures, but in several cells they
will
|| be blanc. I have found that the autosum only works if there are
numbers
in
|| each cell. In this particular document I have subtotals in the right
hand
|| column that I want to total at the end with probably 4 or 5 blanc cells
in
|| between each sub total. To put a formula saying D1+D8+D20 etc and
having
to
|| count down to know the cells to put in the formula, you may as well use
a
|| calculator. Is there any formula you can put that would add all above
|| without having to put a zero in the blanc cells. Could anyone help
please.
||

You could try giving your sub-totals bookmark names (Insert Bookmark).
Then use those names in the formula:
=(Sub1 + Sub2 = Sub3) etc.
or
=SUM(Sub1, Sub2, Sub3)

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org

Thanks very much that works very well, I am very grateful.

Margaret

"macropod" wrote in message
...
Hi Margaret,

Assuming you know how many rows there are to sum, you could use a formula
like:
=SUM(D120)
which won't be affected by blank cells. To do this, select the 'total'
cell
in column D, press Shift-F9 to create a pair of field braces and type the
formula between them. Then press F9 to update the field.

For more information on Word field maths, see:
http://www.wopr.com/cgi-bin/w3t/show...&Number=365442

Cheers


"Margaret Upton" wrote in message
...
I want to be able to add a column of figures, but in several cells they
will
be blanc. I have found that the autosum only works if there are numbers
in
each cell. In this particular document I have subtotals in the right
hand
column that I want to total at the end with probably 4 or 5 blanc cells
in
between each sub total. To put a formula saying D1+D8+D20 etc and
having
to
count down to know the cells to put in the formula, you may as well use
a
calculator. Is there any formula you can put that would add all above
without having to put a zero in the blanc cells. Could anyone help
please.

Margaret





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.684 / Virus Database: 446 - Release Date: 13/05/2004