Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
i need an excel wizard
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=511549 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
i need an excel wizard
Just to get familiar witht the process, try building this example:
First, create a list of students and classes Col_A Col_B Col_C Col_D Students Math English Science Al x x o Ben o x x Clare o x o Dara x x x Ed o (blank) (blank) Second, assign points to classes Col_K Col_L Math 4 English 3 Science 3 Last, create the calculations F1: Req G1: Opt H1: Total F2: =SUMPRODUCT(($B2:$D2="x")*($B$1:$D$1=$K$1:$K$3)*$L $1:$L$3) G2: =SUMPRODUCT(($B2:$D2="o")*($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-Pro "lushus21" wrote: 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=511549 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
i need an excel wizard
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 http://cpearson.com/excel/newposte.htm In article , lushus21 wrote: 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!!!!!!!!!!!!!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
excel template wizard | Excel Discussion (Misc queries) | |||
How to load Template Wizard /tracking to operate in Excel 2003? | Excel Discussion (Misc queries) | |||
Excel Answer Wizard BROKEN | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |