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

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" <JOHABE@discussions.microsoft.com> wrote in message 
news:0E9AF40B-1AE8-4274-95AC-0F5574BBEC08@microsoft.com...
> 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 

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" <JOHABE@discussions.microsoft.com> wrote in message 
news:0E9AF40B-1AE8-4274-95AC-0F5574BBEC08@microsoft.com...
> 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 

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" <JOHABE@discussions.microsoft.com> wrote in message 
> news:0E9AF40B-1AE8-4274-95AC-0F5574BBEC08@microsoft.com...
> > 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 
> 
> 
> .
> 

Hi JOHABE,

For an in-depth discussion of field calculations in Word, check out my Word Field Maths Tutorial, at:
http://lounge.windowssecrets.com/index.php?showtopic=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/index.php?showtopic=249902
or
http://www.gmayor.com/downloads.htm#Third_party

Do read both documents' introductory material.


-- 
Cheers
macropod
[Microsoft MVP - Word]


"JOHABE" <JOHABE@discussions.microsoft.com> wrote in message news:1EA256FA-0C45-4C03-AB6D-791A70E188E7@microsoft.com...
> 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" <JOHABE@discussions.microsoft.com> wrote in message 
>> news:0E9AF40B-1AE8-4274-95AC-0F5574BBEC08@microsoft.com...
>> > 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 
>> 
>> 
>> .
>>

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

Numeric Picture (\#) field switch
http://office.microsoft.com/en-us/word/HP051862261033.aspx?pid=CH061047321033

-- 
Stefan Blom
Microsoft Word MVP



"JOHABE" <JOHABE@discussions.microsoft.com> wrote in message 
news:1EA256FA-0C45-4C03-AB6D-791A70E188E7@microsoft.com...
> 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" <JOHABE@discussions.microsoft.com> wrote in message
>> news:0E9AF40B-1AE8-4274-95AC-0F5574BBEC08@microsoft.com...
>> > 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
>>
>>
>> .
>>