[JOHABE]

hello, I read this under the topic "How to get a formula field to total an
entire table column, even if some cells in the column contain text or are
blank" on the MVP-site and can't get it to work. I'm interested in the final
bit, using ;""
Does anyone know how to do this?

start quotation...

Then in the total cell, press Ctrl+F9, and within the field braces {},
insert the following formula:

{ SUM(Table1 F:F) \# "#,##0.00;- #,##0.00;''" }

€œTable1€� in the formula refers to the name of the bookmark you've marked the
main table with. The formula, being in a different table from the column it's
totalling, wouldn't know which table you were referencing otherwise. The F:F
bit means the 6th column from the left.

The bit at the end of the formula:

;''"

.... means that if there are no values in column F, don't display anything
(otherwise it would display 0.00). I learnt that trick from Word MVP Cindy
Meister.

....end quotation

--
A professional template builder

[Stefan Blom[_3_]]

You probably confused ;''" at the end (semi-colon, two single quotation
marks, double quotation mark) with ;"" (semi-colon, two double quotation
marks).

--
Stefan Blom
Microsoft Word MVP



"JOHABE" wrote in message
...
hello, I read this under the topic "How to get a formula field to total an
entire table column, even if some cells in the column contain text or are
blank" on the MVP-site and can't get it to work. I'm interested in the
final
bit, using ;""
Does anyone know how to do this?

start quotation...

Then in the total cell, press Ctrl+F9, and within the field braces {},
insert the following formula:

{ SUM(Table1 F:F) \# "#,##0.00;- #,##0.00;''" }

"Table1" in the formula refers to the name of the bookmark you've marked
the
main table with. The formula, being in a different table from the column
it's
totalling, wouldn't know which table you were referencing otherwise. The
F:F
bit means the 6th column from the left.

The bit at the end of the formula:

;''"

... means that if there are no values in column F, don't display anything
(otherwise it would display 0.00). I learnt that trick from Word MVP Cindy
Meister.

...end quotation

--
A professional template builder

[Graham Mayor]

If you are *working in the table*, the following will work

{ =SUM(F:F) \# ",0.00;-,0.00;"}

If you are *working outside the table*, display the formatting by clicking
the ¶ button
At the end of each row of the table (outside the table) there is a cell end
character. Put the cursor between one of these characters and the table (it
doesn't matter which) and insert a bookmark - Table1

The following will then work

{ =SUM(Table1 F:F) \# ",0.00;-,0.00;"}


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"JOHABE" wrote in message
...
hello, I read this under the topic "How to get a formula field to total an
entire table column, even if some cells in the column contain text or are
blank" on the MVP-site and can't get it to work. I'm interested in the
final
bit, using ;""
Does anyone know how to do this?

start quotation...

Then in the total cell, press Ctrl+F9, and within the field braces {},
insert the following formula:

{ SUM(Table1 F:F) \# "#,##0.00;- #,##0.00;''" }

"Table1" in the formula refers to the name of the bookmark you've marked
the
main table with. The formula, being in a different table from the column
it's
totalling, wouldn't know which table you were referencing otherwise. The
F:F
bit means the 6th column from the left.

The bit at the end of the formula:

;''"

... means that if there are no values in column F, don't display anything
(otherwise it would display 0.00). I learnt that trick from Word MVP Cindy
Meister.

...end quotation

--
A professional template builder

[JOHABE]

Thanks!
I got it working now, you were right about my confusion...
is this a hidden option of the \# option?
Do u know of a site/article that discusses in-depth word-formulas?
Would be interested in that.
--
A professional template builder


"Stefan Blom" wrote:

You probably confused ;''" at the end (semi-colon, two single quotation
marks, double quotation mark) with ;"" (semi-colon, two double quotation
marks).

--
Stefan Blom
Microsoft Word MVP



"JOHABE" wrote in message
...
hello, I read this under the topic "How to get a formula field to total an
entire table column, even if some cells in the column contain text or are
blank" on the MVP-site and can't get it to work. I'm interested in the
final
bit, using ;""
Does anyone know how to do this?

start quotation...

Then in the total cell, press Ctrl+F9, and within the field braces {},
insert the following formula:

{ SUM(Table1 F:F) \# "#,##0.00;- #,##0.00;''" }

"Table1" in the formula refers to the name of the bookmark you've marked
the
main table with. The formula, being in a different table from the column
it's
totalling, wouldn't know which table you were referencing otherwise. The
F:F
bit means the 6th column from the left.

The bit at the end of the formula:

;''"

... means that if there are no values in column F, don't display anything
(otherwise it would display 0.00). I learnt that trick from Word MVP Cindy
Meister.

...end quotation

--
A professional template builder


.

[macropod[_2_]]

Hi JOHABE,

For an in-depth discussion of field calculations in Word, check out my Word Field Maths Tutorial, at:
http://lounge.windowssecrets.com/ind...owtopic=365442
or
http://www.gmayor.com/downloads.htm#Third_party

After you've digested that, you might also want to check out my Word Date Calculation Tutorial, at:
http://lounge.windowssecrets.com/ind...owtopic=249902
or
http://www.gmayor.com/downloads.htm#Third_party

Do read both documents' introductory material.


--
Cheers
macropod
[Microsoft MVP - Word]


"JOHABE" wrote in message ...
Thanks!
I got it working now, you were right about my confusion...
is this a hidden option of the \# option?
Do u know of a site/article that discusses in-depth word-formulas?
Would be interested in that.
--
A professional template builder


"Stefan Blom" wrote:

You probably confused ;''" at the end (semi-colon, two single quotation
marks, double quotation mark) with ;"" (semi-colon, two double quotation
marks).

--
Stefan Blom
Microsoft Word MVP



"JOHABE" wrote in message
...
hello, I read this under the topic "How to get a formula field to total an
entire table column, even if some cells in the column contain text or are
blank" on the MVP-site and can't get it to work. I'm interested in the
final
bit, using ;""
Does anyone know how to do this?

start quotation...

Then in the total cell, press Ctrl+F9, and within the field braces {},
insert the following formula:

{ SUM(Table1 F:F) \# "#,##0.00;- #,##0.00;''" }

"Table1" in the formula refers to the name of the bookmark you've marked
the
main table with. The formula, being in a different table from the column
it's
totalling, wouldn't know which table you were referencing otherwise. The
F:F
bit means the 6th column from the left.

The bit at the end of the formula:

;''"

... means that if there are no values in column F, don't display anything
(otherwise it would display 0.00). I learnt that trick from Word MVP Cindy
Meister.

...end quotation

--
A professional template builder


.

[Stefan Blom[_3_]]

For more on the "numeric picture" switch, see this article:

Numeric Picture (\#) field switch
http://office.microsoft.com/en-us/wo...CH061047321033

--
Stefan Blom
Microsoft Word MVP



"JOHABE" wrote in message
...
Thanks!
I got it working now, you were right about my confusion...
is this a hidden option of the \# option?
Do u know of a site/article that discusses in-depth word-formulas?
Would be interested in that.
--
A professional template builder


"Stefan Blom" wrote:

You probably confused ;''" at the end (semi-colon, two single quotation
marks, double quotation mark) with ;"" (semi-colon, two double quotation
marks).

--
Stefan Blom
Microsoft Word MVP



"JOHABE" wrote in message
...
hello, I read this under the topic "How to get a formula field to total
an
entire table column, even if some cells in the column contain text or
are
blank" on the MVP-site and can't get it to work. I'm interested in the
final
bit, using ;""
Does anyone know how to do this?

start quotation...

Then in the total cell, press Ctrl+F9, and within the field braces {},
insert the following formula:

{ SUM(Table1 F:F) \# "#,##0.00;- #,##0.00;''" }

"Table1" in the formula refers to the name of the bookmark you've
marked
the
main table with. The formula, being in a different table from the
column
it's
totalling, wouldn't know which table you were referencing otherwise.
The
F:F
bit means the 6th column from the left.

The bit at the end of the formula:

;''"

... means that if there are no values in column F, don't display
anything
(otherwise it would display 0.00). I learnt that trick from Word MVP
Cindy
Meister.

...end quotation

--
A professional template builder


.