[DD]

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.

[Suzanne S. Barnhill]

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.

[DD]

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.

[Jay Freedman]

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.

[Suzanne S. Barnhill]

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.

[DD]

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.

[DD]

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.

[Jay Freedman]

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.