I have an invoice and would like to add the column of charges and subtract
the column of credits and have just that total in one particular cell. How
do I do that.

Hi ?B?Q2hlcmk=?=,

I have an invoice and would like to add the column of charges and subtract
the column of credits and have just that total in one particular cell.

This is in Word? Have you looked at the Table/Formula command? Starting with
Sum(Above) and working from there...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

To do calculations which do not just use the cells above you need to imagine
your table cells labelled as they would be in Excel i.e. Columns A, B, C, etc
rows 1, 2, 3. You can then do things like =(C2+C3)*C4 in the Tables -
Formula window to get the answer you require.

--
Andrea Jones
www.allaboutoffice.co.uk
www.allaboutclait.com
www.stratatraining.co.uk


"Cheri" wrote:

I have an invoice and would like to add the column of charges and subtract
the column of credits and have just that total in one particular cell. How
do I do that.

I've tried that but I get a syntax error. I want to add the charges in
Column C(which has lines 1-7) and subtract any credits that appear in Column
D - lines 1-7) all into a cell at the bottom of Column D - i.e. D10

"Andrea Jones" wrote:

To do calculations which do not just use the cells above you need to imagine
your table cells labelled as they would be in Excel i.e. Columns A, B, C, etc
rows 1, 2, 3. You can then do things like =(C2+C3)*C4 in the Tables -
Formula window to get the answer you require.

--
Andrea Jones
www.allaboutoffice.co.uk
www.allaboutclait.com
www.stratatraining.co.uk


"Cheri" wrote:

I have an invoice and would like to add the column of charges and subtract
the column of credits and have just that total in one particular cell. How
do I do that.

You should be able to click in D10, click on Tables -Formulas and then type

=SUM(C1:C7)-SUM(D17)

Make sure you start the calculation with = or it won't work.

--
Andrea Jones
www.allaboutoffice.co.uk
www.stratatraining.co.uk
www.allaboutclait.com


"Cheri" wrote:

I've tried that but I get a syntax error. I want to add the charges in
Column C(which has lines 1-7) and subtract any credits that appear in Column
D - lines 1-7) all into a cell at the bottom of Column D - i.e. D10

"Andrea Jones" wrote:

To do calculations which do not just use the cells above you need to imagine
your table cells labelled as they would be in Excel i.e. Columns A, B, C, etc
rows 1, 2, 3. You can then do things like =(C2+C3)*C4 in the Tables -
Formula window to get the answer you require.

--
Andrea Jones
www.allaboutoffice.co.uk
www.allaboutclait.com
www.stratatraining.co.uk


"Cheri" wrote:

I have an invoice and would like to add the column of charges and subtract
the column of credits and have just that total in one particular cell. How
do I do that.

Tried that and it puts in a number but it's not the right number. More
suggestions?

"Andrea Jones" wrote:

You should be able to click in D10, click on Tables -Formulas and then type

=SUM(C1:C7)-SUM(D17)

Make sure you start the calculation with = or it won't work.

--
Andrea Jones
www.allaboutoffice.co.uk
www.stratatraining.co.uk
www.allaboutclait.com


"Cheri" wrote:

I've tried that but I get a syntax error. I want to add the charges in
Column C(which has lines 1-7) and subtract any credits that appear in Column
D - lines 1-7) all into a cell at the bottom of Column D - i.e. D10

"Andrea Jones" wrote:

To do calculations which do not just use the cells above you need to imagine
your table cells labelled as they would be in Excel i.e. Columns A, B, C, etc
rows 1, 2, 3. You can then do things like =(C2+C3)*C4 in the Tables -
Formula window to get the answer you require.

--
Andrea Jones
www.allaboutoffice.co.uk
www.allaboutclait.com
www.stratatraining.co.uk


"Cheri" wrote:

I have an invoice and would like to add the column of charges and subtract
the column of credits and have just that total in one particular cell. How
do I do that.

What are the numbers in Cells C1-C7 and D1-D7 and what is the result
showing? Are the numbers in D1-D7
the result of a formula?
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Cheri" wrote in message
news
Tried that and it puts in a number but it's not the right number. More
suggestions?

"Andrea Jones" wrote:

You should be able to click in D10, click on Tables -Formulas and then
type

=SUM(C1:C7)-SUM(D17)

Make sure you start the calculation with = or it won't work.

--
Andrea Jones
www.allaboutoffice.co.uk
www.stratatraining.co.uk
www.allaboutclait.com


"Cheri" wrote:

I've tried that but I get a syntax error. I want to add the charges in
Column C(which has lines 1-7) and subtract any credits that appear in
Column
D - lines 1-7) all into a cell at the bottom of Column D - i.e. D10

"Andrea Jones" wrote:

To do calculations which do not just use the cells above you need to
imagine
your table cells labelled as they would be in Excel i.e. Columns A,
B, C, etc
rows 1, 2, 3. You can then do things like =(C2+C3)*C4 in the
Tables -
Formula window to get the answer you require.

--
Andrea Jones
www.allaboutoffice.co.uk
www.allaboutclait.com
www.stratatraining.co.uk


"Cheri" wrote:

I have an invoice and would like to add the column of charges and
subtract
the column of credits and have just that total in one particular
cell. How
do I do that.

Cheri

Place cursor in a cell where you want the result displayed. Press [Alt+F9].
This will insert a set of curly brackets. In between the curly brackets type
your formula.
ie. "=(a1:e1)" or "=sum(a1:e1)-sum(a2:e2)". When done right click field and
click on 'Update Field'.

Regards
Mike

PS. Inverted commas are used for indicating formulae etc. Don't use in
formula.

"Doug Robbins" wrote:

What are the numbers in Cells C1-C7 and D1-D7 and what is the result
showing? Are the numbers in D1-D7
the result of a formula?
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Cheri" wrote in message
news
Tried that and it puts in a number but it's not the right number. More
suggestions?

"Andrea Jones" wrote:

You should be able to click in D10, click on Tables -Formulas and then
type

=SUM(C1:C7)-SUM(D17)

Make sure you start the calculation with = or it won't work.

--
Andrea Jones
www.allaboutoffice.co.uk
www.stratatraining.co.uk
www.allaboutclait.com


"Cheri" wrote:

I've tried that but I get a syntax error. I want to add the charges in
Column C(which has lines 1-7) and subtract any credits that appear in
Column
D - lines 1-7) all into a cell at the bottom of Column D - i.e. D10

"Andrea Jones" wrote:

To do calculations which do not just use the cells above you need to
imagine
your table cells labelled as they would be in Excel i.e. Columns A,
B, C, etc
rows 1, 2, 3. You can then do things like =(C2+C3)*C4 in the
Tables -
Formula window to get the answer you require.

--
Andrea Jones
www.allaboutoffice.co.uk
www.allaboutclait.com
www.stratatraining.co.uk


"Cheri" wrote:

I have an invoice and would like to add the column of charges and
subtract
the column of credits and have just that total in one particular
cell. How
do I do that.

Ctrl+F9, not Alt+F9

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Mike Faulkner" wrote in message
...
Cheri

Place cursor in a cell where you want the result displayed. Press
[Alt+F9].
This will insert a set of curly brackets. In between the curly brackets
type
your formula.
ie. "=(a1:e1)" or "=sum(a1:e1)-sum(a2:e2)". When done right click field
and
click on 'Update Field'.

Regards
Mike

PS. Inverted commas are used for indicating formulae etc. Don't use in
formula.

"Doug Robbins" wrote:

What are the numbers in Cells C1-C7 and D1-D7 and what is the result
showing? Are the numbers in D1-D7
the result of a formula?
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Cheri" wrote in message
news
Tried that and it puts in a number but it's not the right number. More
suggestions?

"Andrea Jones" wrote:

You should be able to click in D10, click on Tables -Formulas and
then
type

=SUM(C1:C7)-SUM(D17)

Make sure you start the calculation with = or it won't work.

--
Andrea Jones
www.allaboutoffice.co.uk
www.stratatraining.co.uk
www.allaboutclait.com


"Cheri" wrote:

I've tried that but I get a syntax error. I want to add the charges
in
Column C(which has lines 1-7) and subtract any credits that appear
in
Column
D - lines 1-7) all into a cell at the bottom of Column D - i.e. D10

"Andrea Jones" wrote:

To do calculations which do not just use the cells above you need
to
imagine
your table cells labelled as they would be in Excel i.e. Columns
A,
B, C, etc
rows 1, 2, 3. You can then do things like =(C2+C3)*C4 in the
Tables -
Formula window to get the answer you require.

--
Andrea Jones
www.allaboutoffice.co.uk
www.allaboutclait.com
www.stratatraining.co.uk


"Cheri" wrote:

I have an invoice and would like to add the column of charges
and
subtract
the column of credits and have just that total in one particular
cell. How
do I do that.