software

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 quot;xquot; symbolsome are optional (it is optiona for kim to take science ) which is
denoted with a quot;oquot; symboli 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 cellHELP HELP HELP

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

THANK YOU!!!!!!!!!!!!!!!!!!--
lushus21
------------------------------------------------------------------------
lushus21's Profile: www.excelforum.com/member.php...oamp;userid=31475
View this thread: www.excelforum.com/showthread...hreadid=511549Just to get familiar witht the process, try building this example:

First, create a list of students and classes
Col_ACol_BCol_CCol_D
StudentsMathEnglishScience
Alxxo
Benoxx
Clareoxo
Daraxxx
Edo(blank)(blank)

Second, assign points to classes
Col_KCol_L
Math4
English3
Science3

Last, create the calculations
F1: Req
G1: Opt
H1: Total

F2: =SUMPRODUCT(($B2:$D2=quot;xquot;)*($B$1:$D$1=$K$1:$K$3)*$L $1:$L$3)
G2: =SUMPRODUCT(($B2:$D2=quot;oquot;)*($B$1:$D$1=$K$1:$K$3)*$L $1:$L$3)
H2: =SUM(F2:G2)

Copy those formulas down through row 6

If that's what you're looking to do, post back with more questions.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;lushus21quot; wrote:

gt;
gt; don know how to explain but imagine
gt;
gt; Course (eg Math) arcoss the top
gt;
gt; students ( John, Kim...) down the side
gt;
gt; each course is different in lenght( math 4 hours, science 3 hours etc)
gt;
gt;
gt; some are require for some ( john must take math ) which is denoted with
gt; a quot;xquot; symbol
gt;
gt;
gt; some are optional (it is optiona for kim to take science ) which is
gt; denoted with a quot;oquot; symbol
gt;
gt;
gt; i need a column at the end that give me total required hours , total
gt; optional, and total combined
gt;
gt; note: if the course is niether require nor optional then nothing is in
gt; the cell
gt;
gt;
gt; HELP HELP HELP
gt;
gt; if this in not clear please reply and we can chat on MSN or something
gt;
gt; THANK YOU!!!!!!!!!!!!!!!!!!
gt;
gt;
gt; --
gt; lushus21
gt; ------------------------------------------------------------------------
gt; lushus21's Profile: www.excelforum.com/member.php...oamp;userid=31475
gt; View this thread: www.excelforum.com/showthread...hreadid=511549
gt;
gt;

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

cpearson.com/excel/newposte.htm
In article gt;,
lushus21 gt;
wrote:

gt; don know how to explain but imagine
gt;
gt; Course (eg Math) arcoss the top
gt;
gt; students ( John, Kim...) down the side
gt;
gt; each course is different in lenght( math 4 hours, science 3 hours etc)
gt;
gt;
gt; some are require for some ( john must take math ) which is denoted with
gt; a quot;xquot; symbol
gt;
gt;
gt; some are optional (it is optiona for kim to take science ) which is
gt; denoted with a quot;oquot; symbol
gt;
gt;
gt; i need a column at the end that give me total required hours , total
gt; optional, and total combined
gt;
gt; note: if the course is niether require nor optional then nothing is in
gt; the cell
gt;
gt;
gt; HELP HELP HELP
gt;
gt; if this in not clear please reply and we can chat on MSN or something
gt;
gt; THANK YOU!!!!!!!!!!!!!!!!!!