Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2000 Table Formulas
I'm attempting to have Word total the Xs in a row with some cells blank.
This is for an attendance log where X indicates attendance. Is there anyway to do this? Thank you. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2000 Table Formulas
In Excel, yes.
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "DD" wrote in message ... I'm attempting to have Word total the Xs in a row with some cells blank. This is for an attendance log where X indicates attendance. Is there anyway to do this? Thank you. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2000 Table Formulas
But not in Word?
"Suzanne S. Barnhill" wrote: In Excel, yes. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "DD" wrote in message ... I'm attempting to have Word total the Xs in a row with some cells blank. This is for an attendance log where X indicates attendance. Is there anyway to do this? Thank you. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2000 Table Formulas
Excel has a COUNTA function that counts the number of non-blank cells in a
given range. Word doesn't have that function. (Both Word and Excel have a COUNT function that counts only cells that contain numbers, but that won't help with Xs.) If you really must keep the attendance log in Word, you'd need a macro to count Xs. Do you really want to go to that effort? -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. DD wrote: But not in Word? "Suzanne S. Barnhill" wrote: In Excel, yes. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "DD" wrote in message ... I'm attempting to have Word total the Xs in a row with some cells blank. This is for an attendance log where X indicates attendance. Is there anyway to do this? Thank you. |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2000 Table Formulas
The alternative is to use, say, 1 instead of X and "count" (or sum) those.
You'll still need to give a specific cell range (the Sum(Above) function won't work if there are blank cells) in the formula. Alternatively, you can do this manually by selecting the column, and doing one of the following: 1. Ctrl+H. Replace X with X. Word will tell you how many replacements it made. 2. Ctrl+F. In the Find dialog, check the box for "Highlight all items found" in "Current Selection." Word will tell you how many it selected. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Jay Freedman" wrote in message ... Excel has a COUNTA function that counts the number of non-blank cells in a given range. Word doesn't have that function. (Both Word and Excel have a COUNT function that counts only cells that contain numbers, but that won't help with Xs.) If you really must keep the attendance log in Word, you'd need a macro to count Xs. Do you really want to go to that effort? -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. DD wrote: But not in Word? "Suzanne S. Barnhill" wrote: In Excel, yes. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "DD" wrote in message ... I'm attempting to have Word total the Xs in a row with some cells blank. This is for an attendance log where X indicates attendance. Is there anyway to do this? Thank you. |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2000 Table Formulas
This particular log used to be in Excel, which was much easier. It has been
changed to Word and we are required to follow suit (unfortunately)! It's my understanding I could also keep track of the attendance in Excel and have it link to Word. Is that easier or more difficult? "Jay Freedman" wrote: Excel has a COUNTA function that counts the number of non-blank cells in a given range. Word doesn't have that function. (Both Word and Excel have a COUNT function that counts only cells that contain numbers, but that won't help with Xs.) If you really must keep the attendance log in Word, you'd need a macro to count Xs. Do you really want to go to that effort? -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. DD wrote: But not in Word? "Suzanne S. Barnhill" wrote: In Excel, yes. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "DD" wrote in message ... I'm attempting to have Word total the Xs in a row with some cells blank. This is for an attendance log where X indicates attendance. Is there anyway to do this? Thank you. |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2000 Table Formulas
Thank you. I will give this a shot!
"Suzanne S. Barnhill" wrote: The alternative is to use, say, 1 instead of X and "count" (or sum) those. You'll still need to give a specific cell range (the Sum(Above) function won't work if there are blank cells) in the formula. Alternatively, you can do this manually by selecting the column, and doing one of the following: 1. Ctrl+H. Replace X with X. Word will tell you how many replacements it made. 2. Ctrl+F. In the Find dialog, check the box for "Highlight all items found" in "Current Selection." Word will tell you how many it selected. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Jay Freedman" wrote in message ... Excel has a COUNTA function that counts the number of non-blank cells in a given range. Word doesn't have that function. (Both Word and Excel have a COUNT function that counts only cells that contain numbers, but that won't help with Xs.) If you really must keep the attendance log in Word, you'd need a macro to count Xs. Do you really want to go to that effort? -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. DD wrote: But not in Word? "Suzanne S. Barnhill" wrote: In Excel, yes. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "DD" wrote in message ... I'm attempting to have Word total the Xs in a row with some cells blank. This is for an attendance log where X indicates attendance. Is there anyway to do this? Thank you. |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Word 2000 Table Formulas
It's pretty easy. To start:
- Set up the log in Excel, using the COUNTA function where needed, and save it. - Copy that section of the worksheet to the clipboard. - Switch into Word. - Click Edit Paste Special. In the list, select "Microsoft Office Excel Worksheet Object" and click OK. You'll get what looks like an ordinary Word table. At any time later, if you double-click the table, it becomes a section of active Excel worksheet that you can edit. Or you can right-click it and choose Worksheet Object, and then click either Edit (for the same worksheet-within-Word) or Open (to see the sheet in Excel, with all the Excel menus and toolbars). When you've completed the edit, click outside the worksheet to return it to being a Word table. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Wed, 10 Jan 2007 12:43:01 -0800, DD wrote: This particular log used to be in Excel, which was much easier. It has been changed to Word and we are required to follow suit (unfortunately)! It's my understanding I could also keep track of the attendance in Excel and have it link to Word. Is that easier or more difficult? "Jay Freedman" wrote: Excel has a COUNTA function that counts the number of non-blank cells in a given range. Word doesn't have that function. (Both Word and Excel have a COUNT function that counts only cells that contain numbers, but that won't help with Xs.) If you really must keep the attendance log in Word, you'd need a macro to count Xs. Do you really want to go to that effort? -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. DD wrote: But not in Word? "Suzanne S. Barnhill" wrote: In Excel, yes. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "DD" wrote in message ... I'm attempting to have Word total the Xs in a row with some cells blank. This is for an attendance log where X indicates attendance. Is there anyway to do this? Thank you. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
I am having difficulty with deleting headers and footers | New Users | |||
Word & WordPerfect | Microsoft Word Help |