HELP !!!! excel question

[lushus21]

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 wit
a "x" symbol


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


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

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


HELP HELP HELP

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

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

 

[Centurius]

if you haven't figured this in 4-5 hours, thats when i'll be home from
work and on msn.

shouldn't be too difficult

centurius (at) hotmail.com

 

[Bob Phillips]

Put the course names in say D1:M1
Put the course length in D2:M2
Put the pupil names in A2:An
The x/o will go in D3:Mn

In B2 add
=SUM(IF($D3:$M3="x",D$2:M$2))

in C2 add
=SUM(IF($D3:$M3="o",D$2:M$2))

and copy down to row n.

these are array formulae, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)