Formula to add

[Margaret Upton]

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

 

[Jean-Guy Marcil]

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
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[macropod]

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/showflat.pl?Cat=&Board=wrd&Number=365442

Cheers

 

[Margaret Upton]

Jean

Thank you very much will try that.

Margaret

 

[Margaret Upton]

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

Margaret