Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Using Formulas in a Word Table
I'm using word '07 & have a table in there that acts much like a roster of
people. I would like to have checkboxes going down each column & at the bottom row total the amount of ticked checkboxes. I tried the formula =IF(C2:C36, "TRUE") & I get a syntax error. I also would like the total the amount of peoples names in another column. I tried =COUNTIF(B2:B36, "*") Are these formulas not allowed in Word? I know they will work in Excel, but I need to do this in a word doc. Is there another way to do what I'm wanting to do? Please help.... |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Using Formulas in a Word Table
Hi silentpro,
Unfortunately, there's no way for a formula field in Word to test the state of a checkbox formfield (which I presume is what you are using). You need to use vba for this. However, you could use a seies of dropdown formfields, where the user selects 1 or 0 and use a formula field to do the calculations based on that. Also, Word's supported range of formulae is nowhere near as rich as Excel's - you can't use SUMIF, for example - and the syntax is different. To see how to do a wide range of other calculations in Word, check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showtopic=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [MVP - Microsoft Word] "silentpro" wrote in message ... I'm using word '07 & have a table in there that acts much like a roster of people. I would like to have checkboxes going down each column & at the bottom row total the amount of ticked checkboxes. I tried the formula =IF(C2:C36, "TRUE") & I get a syntax error. I also would like the total the amount of peoples names in another column. I tried =COUNTIF(B2:B36, "*") Are these formulas not allowed in Word? I know they will work in Excel, but I need to do this in a word doc. Is there another way to do what I'm wanting to do? Please help.... |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Using Formulas in a Word Table
thanks for the link... lotta cool stuff in there.
Is there a work around for what I'm trying to do? I didn't see it in your math file.... I would like to count the number of cells in a column that have text in it. I would also like to count the number of "TRUE" (ticked) checkboxes. Then reference those totals in another cell elsewhere on the sheet. "macropod" wrote in message ... Hi silentpro, Unfortunately, there's no way for a formula field in Word to test the state of a checkbox formfield (which I presume is what you are using). You need to use vba for this. However, you could use a seies of dropdown formfields, where the user selects 1 or 0 and use a formula field to do the calculations based on that. Also, Word's supported range of formulae is nowhere near as rich as Excel's - you can't use SUMIF, for example - and the syntax is different. To see how to do a wide range of other calculations in Word, check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showtopic=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [MVP - Microsoft Word] "silentpro" wrote in message ... I'm using word '07 & have a table in there that acts much like a roster of people. I would like to have checkboxes going down each column & at the bottom row total the amount of ticked checkboxes. I tried the formula =IF(C2:C36, "TRUE") & I get a syntax error. I also would like the total the amount of peoples names in another column. I tried =COUNTIF(B2:B36, "*") Are these formulas not allowed in Word? I know they will work in Excel, but I need to do this in a word doc. Is there another way to do what I'm wanting to do? Please help.... |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Using Formulas in a Word Table
Hi silentpro,
As I mentioned in my previous post, you could use a seies of dropdown formfields, where the user selects 1 or 0 and use a formula field to do the calculations based on that. A suitable field code might look like: {=SUM(C2:C36)} or, if you're a masochist: {={REF Dropdown1}+{REF Dropdown2}... +{REF Dropdown34}+{REF Dropdown35}} Unfortunately, however, you can't use a formula field to count the cells containing the peoples' names unless there's a '1' (which could be formatted as hidden text) and no other numbers in each of those cells - then you could use: {=SUM(B2:B36)} Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. -- Cheers macropod [MVP - Microsoft Word] "silentpro" wrote in message ... thanks for the link... lotta cool stuff in there. Is there a work around for what I'm trying to do? I didn't see it in your math file.... I would like to count the number of cells in a column that have text in it. I would also like to count the number of "TRUE" (ticked) checkboxes. Then reference those totals in another cell elsewhere on the sheet. "macropod" wrote in message ... Hi silentpro, Unfortunately, there's no way for a formula field in Word to test the state of a checkbox formfield (which I presume is what you are using). You need to use vba for this. However, you could use a seies of dropdown formfields, where the user selects 1 or 0 and use a formula field to do the calculations based on that. Also, Word's supported range of formulae is nowhere near as rich as Excel's - you can't use SUMIF, for example - and the syntax is different. To see how to do a wide range of other calculations in Word, check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showtopic=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [MVP - Microsoft Word] "silentpro" wrote in message ... I'm using word '07 & have a table in there that acts much like a roster of people. I would like to have checkboxes going down each column & at the bottom row total the amount of ticked checkboxes. I tried the formula =IF(C2:C36, "TRUE") & I get a syntax error. I also would like the total the amount of peoples names in another column. I tried =COUNTIF(B2:B36, "*") Are these formulas not allowed in Word? I know they will work in Excel, but I need to do this in a word doc. Is there another way to do what I'm wanting to do? Please help.... |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to copy formulas within a table in Word? | Tables | |||
Word 2000 Table Formulas | Microsoft Word Help | |||
use excel table with formulas in Word | Microsoft Word Help | |||
MS Word Table Formulas?? | Tables | |||
WORD TABLE FORMULAS Forms | Tables |