Hi. I've been handed an excel file that needs tweaking. Was wondering if
someone here could help.

This xls file consists of 7 worksheets, one of every day of the week. Each
worksheet has a 30 column section, each marked either [X] or [ ]. There's
one row for each person, the columns represent their 1/2 hour schedule.

1) I need a totals column, totaling the # of Xs in the 30 columns for that
person. Is there a way to determine if a cell has an [X] or not? If so,
add 1 to a count?

2) This totals column also needs to show department sub-total and grand
total. Should be easy enough, but I need to print a summary version of the
worksheet, showing just the department totals.

3) I figure the next thing the client will ask to a printed report showing
department totals of the whole week, all 7 worksheets. Is that possible?

As you may have guessed, I'm not an Excel person. First chance I get, I'll
run down to B&N and find an Excel reference book. Any advice from this
newsgroup will still be greatly appreciated...Dennis