That's great, thanks.
However, how can I restrict the user from accidently entering a space char
or any other char while I'm asking. I would like a Verification warning
atleast.
BTW, no row totals in right most column is needed.
Thanks again.

"Susan" wrote:

just put an "x" in each activity column/row.
at the bottom of each column (or at the end of each row, if you'd
rather) have a counta formula:

=counta(a2:a25)

that will give you the # of x's in each row.
OH WAIT, that won't work. because it will also count the wording
you've got there for either name or activity........

try this instead:

=countif(a2:d2,"x") this is for rows
=countif(a2:a25,"x") this is for columns

now it will only count the x's.
hope it helps (or at least gets you started!)
:)
susan



On Dec 24, 3:52 pm, Bupkus wrote:
I have a table of 25 columns and a variable number of rows. Each row
represents a person and each column represents an activity. If person has
requested an activity then user mouse clicks in cell to mark person to that
activity. Bottom row has totals for each activity.
I would like a checkbox matrix where cells with checked box are counted in
the Totals row.
I'm over my head here and time doesn't allow for me any more research.
Thanks.