This may not be what you want but it will work
Insert 1 column to the right of your dates (Row 13 thru 25) and then
enter the following formula.
=IF(AND(B13=$D$7,B13<=$F$7),$C$7,IF(AND(B13=$D$8 ,B13<=$F$8),$C$8,IF(AND(B13=$D$9,B13<=$F$9),$C$9, "Check"))).
The above formual will put a #1, #2, #3 into the column to indicate
semster.

Then in cell D41 do the following formula:
=SUMIF(C13:C26,"=#1",D13:D26)

The "straight" SUMIF probably won't work because you have an "AND"
condition

Also if it doesn't compute correctly you may have to use DD MMM YY
format


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2309223