i need an EXCEL wizard
 

:confused: I 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!!!!!!!!!!!!!!!!!!


--
lushus21
------------------------------------------------------------------------
lushus21's Profile: http://www.excelforum.com/member.php...o&userid=31475
View this thread: http://www.excelforum.com/showthread...hreadid=511545

i need an EXCEL wizard
 

One way:

Imagine the setup this way:

A B C D ... J K L
1 Math Science History Req'd Opt Total
2 4 3 2
3 Bill x o
4 Bob x o
5 Brenda x x x
....

Then

J3: =SUMIF(B3:I3,"x",B$2:I$2)
K3: =SUMIF(B3:I3,"o",B$2:I$2)
L3: =J3+K3

Copy J3:L3 down as far as required



In article ,
lushus21
wrote:

:confused: I 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!!!!!!!!!!!!!!!!!!

i need an EXCEL wizard
 

lushus21,

Assuming:
Course Names are in B2:J2, Course times are in B3:J3 as numbers,Student
Names start in A4

Total Required:
=SUMPRODUCT((B4:J4="x")*(B3:J3))

Total Optional:
=SUMPRODUCT((B4:J4="o")*(B3:J3))

Total of both Required & Optional:
=SUMPRODUCT((B4:J4="x")*(B3:J3)+(B4:J4="o")*(B3:J3 ))

or 'Total Required' cell + 'Total Optional' cell


--
HTH

Sandy

with @tiscali.co.uk


"lushus21" wrote in
message ...

:confused: I 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!!!!!!!!!!!!!!!!!!


--
lushus21
------------------------------------------------------------------------
lushus21's Profile:
http://www.excelforum.com/member.php...o&userid=31475
View this thread: http://www.excelforum.com/showthread...hreadid=511545