Modify sumproduct formula

Hi

I have been using a SUMPRODUCT formula noted in column K. The formula sums the values associated column 0100 & 0200 for a specific line. It has worked spectacularly. I tried and failed to modify the formula to accomplish a bit more. I would like to accomplish the following examples: modify the formula in K11 to exclude, not sum column 0200 and (2) to modify the formula in K27 to sum lines 06300 to 10099 but exclude line 09500 column 0100 and 0200 because it is a subtotal.

Appreciate the help.

One other quick question: can you recommend a newbie book illustrating the kinds of formulae and changes noted above?

Thanks again.

Al

Is this what you want for K11

=SUMPRODUCT(--($C$2:$C$1404>=J10),--($C$2:$C$1404<=J11),--($D$2:$D$1404 ="0100"), $E$2:$E$1404)

Yes, thank you - it worked.

Do you have any suggestions for K27 on the attached file?

Thanks again.

Al

Sorry, but I couldn't follow what you wanted for that one.

Sorry for the lack of clarity. If you don't mind, I'll try to explain it again. K27 asks Excel to sum columns 0100 & 0200 for lines 06300 to 09699. In doing so, the formula includes the values in columns 0100 & 0200 for line 09500. I would like the formula to sum 06300 to 09699 while excluding the 09500 values.

Hope this clarifies my request.

Thanks again.

Al