Frick,

I would break the problem down by using hidden cells to do some of the
calculations. For example to SUM for Semester#1 I would use:

=SUMPRODUCT(--(B13:B31=D7),--(B13:B31<=F7),C13:C31)

and to calculate either the lowest two from either Semester#1 or the Total
try simething like:

=IF(J7="S",SUM(SMALL(IF(--((B13:B31=D7)*--(B13:B31<=F7)*C13:C31)0,C13:C31),{1,2})),SUM(SMAL L(C13:C31,{1,2})))

which is an array formula committed by Ctrl + Shift + Enter

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Frick" wrote in message
...

The formula unfortunetly did not accomplish what I needed. Perhaps I
did not explain it clearly, which I apologize for. I have attached a
excel sheet that I called Example.zip that hopefully addresses my two
problems that I have listed on the sheet. I hope someone can help me
resolve these issues.

Thanks again for all help provided.


+-------------------------------------------------------------------+
|Filename: Example.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4123 |
+-------------------------------------------------------------------+

--
Frick
------------------------------------------------------------------------
Frick's Profile:
http://www.excelforum.com/member.php...o&userid=29629
View this thread: http://www.excelforum.com/showthread...hreadid=493231