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!!!!!!!!!!!!!!!!!!