See one possibility in m.p.excel.newusers

Please don't post the same question in multiple newsgroups. At best, it
tends to fragment any answers. OTOH, it potentially wastes the time of
someone responding to a problem that has already been answered.

For tips on using these newsgroups effectively, see

http://cpearson.com/excel/newposte.htm



In article ,
lushus21
wrote:

don know how to explain but imagine

Course (eg Math) arcoss the top

students ( John, Kim...) down the side

each course is different in lenght( math 4 hours, science 3 hours etc)


some are require for some ( john must take math ) which is denoted with
a "x" symbol


some are optional (it is optiona for kim to take science ) which is
denoted with a "o" symbol


i need a column at the end that give me total required hours , total
optional, and total combined

note: if the course is niether require nor optional then nothing is in
the cell


HELP HELP HELP

if this in not clear please reply and we can chat on MSN or something

THANK YOU!!!!!!!!!!!!!!!!!!