i need an EXCEL wizard

L

lushus21

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

JE McGimpsey

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
 
S

Sandy Mann

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
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top